Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Key in apostrophe
Message
 
 
To
16/09/2004 01:39:44
Yh Yau
Ingenuity Microsystems Sdn Bhd
Kuala Lumpur, Malaysia
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00942689
Message ID:
00942893
Views:
19
This message has been marked as the solution to the initial question of the thread.
lcsqlstringa = STRTRAN(remoteview.field , ['], [''])
lcsqlstringb = [insert into table (field) values ('] + lcsqlstringa + [')]
>I use the sqlexec as follow:-
>lcsqlstringa = remoteview.field (where this is a character field)
>lcsqlstringb = "insert into table (field) values "+lcsqlstringa
>then sqlexec(connectionhandle, lcsqlstringb)
>So now, I should change this into :-
>lcsqlstringb = "insert into table (field) values "+[lcsqlstringa] ?
>Is that correct?
>Yau
--sb--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform