Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 data type

Author  Topic 

Risqi Aris
Starting Member

13 Posts

Posted - 2011-10-18 : 21:16:31
I need a data type that can store the "enter" character .. What data type should I use?
pleace, help me...

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2011-10-18 : 21:18:02
varchar/nvarchar/char/nchar/text

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

Risqi Aris
Starting Member

13 Posts

Posted - 2011-10-18 : 23:37:34
but when I show the data from sqlserver 2000 to vb 6 the result is no "enter" and even straight appearance there is no "enter"..
Go to Top of Page

Risqi Aris
Starting Member

13 Posts

Posted - 2011-10-18 : 23:37:40
but when I show the data from sqlserver 2000 to vb 6 the result is no "enter" and even straight appearance there is no "enter"..
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2011-10-18 : 23:49:36
You've got a problem in your vb6 code then or the data doesn't contain the character you think it does.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

Risqi Aris
Starting Member

13 Posts

Posted - 2011-10-19 : 00:21:04
when I browse the table and hold my press enter but the data from the table into 2 ...
is there another way?
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2011-10-19 : 00:26:40
I have no idea what you are doing but it's like you aren't using a query window like you should be. Here's a test to show that this can be done. Make sure you view the output in text and not in grid mode.

create table t1 (c1 varchar(100))

insert into t1 values ('test
test



test
')

select * from t1

drop table t1

The above script returns this output:

c1
----------------------------------------------------------------------------------------------------
test
test



test


Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

Risqi Aris
Starting Member

13 Posts

Posted - 2011-10-19 : 01:02:25
so i have to display the textbox vb6 using and not using DataGrid?
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2011-10-19 : 12:38:53
I can't help you with vb6. I'm a SQL person.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

Risqi Aris
Starting Member

13 Posts

Posted - 2011-10-19 : 23:16:53
ok thanks for all your help ...
Go to Top of Page
   

- Advertisement -