artificiality
Registered User.
- Local time
- Today, 11:12
- Joined
- Jan 30, 2007
- Messages
- 20
sqlSt = ""
sqlSt = sqlSt & "INSERT INTO RawData(RunID,fullName,name,category,type,subType,numberOfLines,virtual,date,namespace)"
sqlSt = sqlSt & " SELECT " & RunID & " ,fullName,name,category,type,subType,numberOfLines,virtual," & "#" & d & "#" & ",namespace FROM RawData "
sqlSt = sqlSt & " WHERE namespace = " & "'" & namespace & "'" & " AND RunID = " & id
id = 256
Why do I get on debug for sqlSt :
"INSERT INTO RawData(RunID,fullName,name,category,type,subType,numberOfLines,virtual,date,namespace) SELECT 257 ,fullName,name,category,type,subType,numberOfLines,virtual,#1/3/2007#,namespace FROM RawData WHERE namespace = 'customer.demo' AND RunID " Where is the id value ?
sqlSt = sqlSt & "INSERT INTO RawData(RunID,fullName,name,category,type,subType,numberOfLines,virtual,date,namespace)"
sqlSt = sqlSt & " SELECT " & RunID & " ,fullName,name,category,type,subType,numberOfLines,virtual," & "#" & d & "#" & ",namespace FROM RawData "
sqlSt = sqlSt & " WHERE namespace = " & "'" & namespace & "'" & " AND RunID = " & id
id = 256
Why do I get on debug for sqlSt :
"INSERT INTO RawData(RunID,fullName,name,category,type,subType,numberOfLines,virtual,date,namespace) SELECT 257 ,fullName,name,category,type,subType,numberOfLines,virtual,#1/3/2007#,namespace FROM RawData WHERE namespace = 'customer.demo' AND RunID " Where is the id value ?