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 Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
pass a string to ADO recordset?
Thanks y'all. Here's what worked... Best, L ' START RECODES FOR YOUNG AGE CATEGORY (3-8 MONTHS) ' If rsado3![age3] = 1 Then ' rsado4.Open "select * from tbl_agpe_recode_vars where agecat = 1;", cnn, adOpenKeyset, adLockOptimistic ' Do While Not rsado4.EOF ' tvar =...- gmrbase
- Post #4
- Forum: Microsoft: Access Modules (VBA Coding)
-
pass a string to ADO recordset?
Hi folks, I have an issue where I want to recode about 100 fields in a table ("Source Table" rsado3) into new values in a different table ("Target Table"). To do this, I've tried to automate it by storing field names from Source Table and Target Table in a third table ("Lookup Table", rsado4)...- gmrbase
- Thread
- Replies: 3
- Forum: Microsoft: Access Modules (VBA Coding)
-
Pass a string to execute stmt?
Firebird has this solution: EXECUTE IMMEDIATE (:stringvar | 'literal string') to do this. Does not work in Marathon though.- gmrbase
- Post #2
- Forum: Embarcadero: InterBase
-
Pass a string to execute stmt?
Dear all, In SQL Server you can pass a string variable or literal string to an EXECUTE statement thus: execute (:stringvar) /* Where :stringvar is varchar with value 'select * from table' --OR*/ Execute ('select * from table') I'm using Marathon 1.1 to try and replicate this...- gmrbase
- Thread
- Replies: 1
- Forum: Embarcadero: InterBase
