Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
VFP to Access Again
Message
From
01/05/2008 15:05:20
Dave Nantais
Light speed database solutions
Ontario, Canada
 
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Environment versions
Visual FoxPro:
VFP 9
OS:
Windows XP
Miscellaneous
Thread ID:
01314382
Message ID:
01314595
Views:
6
Because of the fonts used on the UT its a bit hard to read the code and the nested quotes....
therefore I've posted the same code but spaced out so its more easily readable.


lnResult = ;
SQLEXEC(lnHandle, "INSERT INTO accounts " + ;
"(pswd) VALUES ( 'ExactPassword' ) "


m.lcMyInsertCommand = ;
" INSERT INTO accounts (pswd) VALUES ' " + m.lcMyPassword + " ' ) "

lnResult = SQLEXEC(lnHandle , m.lcMyInsertCommand )


let me know how well this technique works :)

Dave.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform