Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Test for working
Message
 
To
26/01/2006 14:56:16
Dragan Nedeljkovich (Online)
Now officially retired
Zrenjanin, Serbia
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
01090344
Message ID:
01090656
Views:
10
>What do you mean damage?
Thanks

An insert or update implies stuff is to be written to a SQL table. The "wizard" has an interface wher the user can enter a SQL statement. If the SQL statement calls an SP or issues an INSERT from the client, there is data in the parameters that is written to the tables. I just want to assure that the statement is syntactically correct (fieldnames - statement structure) without actually writing to the table - and - without actually passing real data and inserting a record into the table.

On the winzard for each statement is a "Test" button the user can click once the statement is in. If the SQL is an INSERT, I would like to assure the user that the statement is syntactically correct (when they press "Test") without actually writting anything to the table.

With SELECT statements I can test without having to "gather" data - I can make select return a zero record cursor. I am looking for a "zero" action insert!
Imagination is more important than knowledge
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform