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 SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: aiyoyo
- Order by date
-
HOW TO CALL FUNCTION WITH SQL STATEMENT IN VISUAL BASIC
Oh, I see what you want to do finally. if u want to work with so many kinds of data destination, the only way is to generate data one by one in a loop.- aiyoyo
- Post #7
- Forum: Data Warehousing/Big Data
-
HOW TO CALL FUNCTION WITH SQL STATEMENT IN VISUAL BASIC
Hi, gthandle, Try to write your myfunction in access mdb file, then use the SQL: "UPDATE [table] set field1 = myfunction()" if you want to pass a field, the SQL should be: "UPDATE [table] set field1 = myfunction([field1])"- aiyoyo
- Post #5
- Forum: Data Warehousing/Big Data
-
HOW TO CALL FUNCTION WITH SQL STATEMENT IN VISUAL BASIC
cos your function, myfunction, is a VB function, not a database's function. in the case of MS Access, the function is stored in the access file, so when you execute the SQL, the function can be found. to make it work, change your SQL to: "UPDATE [table] set field1 = '" & myfunction()...- aiyoyo
- Post #2
- Forum: Data Warehousing/Big Data
-
Polling Solutions? (remote data retrieval)
I think Sybase provides a good solution for your case. you can place SQL Anywhere in each restaurant to gather the local data, then use SQL Remote or Replication Server to transfer these data to the center. you will find some cases at Sybase's(www.sybase.com).- aiyoyo
- Post #3
- Forum: Data Warehousing/Big Data
