Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Allan320
Starting Member
2 Posts |
 Posted - 2006-06-08 : 11:23:28
|
| Hi there. I have a database that uses a form to send data to a csv file. I am wanting the contents of the form to be sent to a table and to the csv file.The problem is the query i have is pulling data from the table and putting it into the csv file, instead of pulling it from the form. I would like it to pull data from the record im working on. Is there any SQL code that can do this.So basically i am wanting it to pull data from the current record and not from the tableThanks Allan |
|
|
timmy
Master Smack Fu Yak Hacker
1242 Posts |
Posted - 2006-06-08 : 19:32:26
|
| I would create a function that converts a recordset to a csv (not hard - should take you about 10 lines to do it simply). Then you can pass the current form's recordset to the new function (you can use Form.RecordsetClone). btw - I did something similar recently and got problems with type mismatches. I got around it by writing my function to accept the recordset as a variant, then casting it to a recordset once in the function. HTH,Tim |
 |
|
|
Allan320
Starting Member
2 Posts |
Posted - 2006-06-09 : 04:26:46
|
| Do you know where i would find any example code for this. Its just to have a look at and see where im going wrong? Thank YouAllan |
|
|
|
|
|
|
Query Help