Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQL Insert command prompting for value
Message
 
 
To
08/06/2006 08:56:40
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
01127719
Message ID:
01127823
Views:
10
Jerry,

Is that the exact code being used? What if you declare the memvars private instead of local?

If you have local variables and you are actually calling a SQLObject method or a SQLExec() wrapper function the variables will not be in scope when SQLExec() is called and VFP will prompt you to supply the values.

>The code that Cetin used is the same that I used. I see that he removed the extra commas. I had several other fields in my code that I removed when I copied it into my message here but left in extra commas. I also tried concatenating as you suggest but it is still prompting me for the values.
df (was a 10 time MVP)

df FoxPro website
FoxPro Wiki site online, editable knowledgebase
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform