Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Cetin Basoz
  Where is Cetin Basoz?
 Izmir
 Turkey
 Cetin Basoz
 To: Kazi Hasan Mahamud
  Where is Kazi Hasan Mahamud?
 dhaka
 Bangladesh
 Kazi Hasan Mahamud
 Tags
Subject: RE: SQL Connectivity and store data in curso
Thread ID: 345414 Message ID: 345449 # Views: 44 # Ratings: 0
Version: Visual FoxPro 7 Category: ODBC, ADO and OLEDB
Date: Wednesday, May 23, 2012 12:40:31 PM         
   


> >
> > This may not solve your problem but anyway first do it the right way:
> >
> >
nhandle = SQLCONNECT('SQLcon')
> > IF m.nhandle >0
> >    local accountID
> >    accountID = ALLTRIM(This.Value)
> >    sqlquery = SQLEXEC(nhandle,"select acc_id_001 from headfile where ACCOUNT_ID=?m.accountID","h_1")		
> >    select h_1
> > endif

> >
> > What is the datatype of accountId?
> >
> >

> > Cetin Basoz
> >
> > .Net has got better.Think about moving - check my blog:
> > My Blog
> > Blog (mirror) - sounds to be down
> >

> > Support Wikipedia
>
>
> Account ID is text data type

Isn't that a very strange datatype for something like accountID? Would you store anything more than 8000 characters there? If not use char or varchar. Text datatype is depreceated anyway, use varchar(max) if you really meant text. Ask your DBA why it was designed as text.



Cetin Basoz

.Net has got better.Think about moving - check my blog:
My Blog
Blog (mirror) - sounds to be down


Support Wikipedia

ENTIRE THREAD

SQL Connectivity and store data in curso Posted by Kazi Hasan Mahamud @ 5/23/2012 9:15:03 AM
RE: SQL Connectivity and store data in curso Posted by Cetin Basoz @ 5/23/2012 10:21:27 AM
RE: SQL Connectivity and store data in curso Posted by Kazi Hasan Mahamud @ 5/23/2012 11:37:16 AM
RE: SQL Connectivity and store data in curso Posted by Cetin Basoz @ 5/23/2012 12:40:31 PM
RE: SQL Connectivity and store data in curso Posted by Kazi Hasan Mahamud @ 5/24/2012 7:21:16 AM
RE: SQL Connectivity and store data in curso Posted by Cetin Basoz @ 5/24/2012 1:40:33 PM
RE: SQL Connectivity and store data in curso Posted by Michel Levy @ 5/24/2012 2:15:44 PM
RE: SQL Connectivity and store data in curso Posted by Cetin Basoz @ 5/24/2012 2:47:54 PM
RE: SQL Connectivity and store data in curso Posted by Michel Levy @ 5/24/2012 3:56:08 PM