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 "TableOfContents"."DateTime" <> {?datetime};
SELECT * FROM "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
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 "TableOfContents"."DateTime" <> {?datetime};
SELECT * FROM "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