Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

insert data dynamically into sql server

Status
Not open for further replies.

tomgao

Programmer
Feb 25, 2003
30
NG
how do I insert data into my sql server from my crystal report as it runs ?

in this article below it suggests that I use CR to insert data into sql server. but I'm having trouble inserting this query into the expert.. as its not picking up on the return field/

I am using crystal report .net ...

this sql query
INSERT INTO "TableOfContents" VALUES ('{?group}', {?page},{?datetime})
DELETE FROM "TableOfContents"
WHERE &quot;TableOfContents&quot;.&quot;DateTime&quot; <> {?datetime};
SELECT * FROM &quot;TableOfContents

would not pickup the fact that I am selecting * from ....

as a result I can't continue with the expert...

appreciate any help

thankyou
Tom
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top