VisuRao,
You say that you are changing O/S from Win98 to Win2000, changing the database from SQLServer v7 to SQLServer v2000 and reports from Crystal Reports v7 to v8.5 !! The apps probably were also compiled in Win98 with ADO2.5 which, when compiled in Win2000, will become ADO2.7
May I...
May I suggest the following:
IF rs.BOF = FALSE AND rs.EOF = FALSE THEN
rs.MOVELAST
lngRecMax = rs.RECORDCOUNT
rs.MOVEFIRST
FOR iCnt = 0 TO lngRecMax - 1 STEP 1
sData = rs.FIELDS("<ColumnName>").value
MEXT
END IF
You'll increase the speed because...
Kleeks -
I can reproduce your errmsg (Win98, mySQL 3.23)when I stop my mySQLAdmin server, and attempt to start mySQL. Start winmySQLAdmin server first. Takes a few moments. Might as well also recheck your winmySQLAdmin, my.ini and myODBC drivers configurations, just to get off on the right...
Try the DATE_ADD function:
SELECT DATE_ADD(dateTimeField,INTERVAL gmtDifference HOUR);
YEAR, MONTH, DAY, HOUR, MINUTE, SECOND are valid intervals, and + and - can be used to indicate direction.
GMT is 5 hours GREATER than EST (Greenwich is East of us), if I remember correctly.
I won't give you an answer that you can cut-and-paste, but the following will point you to your answer. You can create databases and tables with VB6 using ADO or via SQL. The following is for ADO
1) Add to references:
ActiveX Data Objects 2.5 Libary
ADO Ext 2.5 for DDL and Security (ADOX)...
The simplest way is to use if/else/endif, and a list of product codes that require dollars. For example:
private sub button_click()
if len(trim(name.txt)) > 0 and _
len(trim(date.txt)) > 0 and _
len(trim(prodcode.txt)) > 0 then
if instr(1,pc_with_dollar,prodcode.text) > 0 then...
The following coding sequence for insert, update and delete database operations using ADO will keep your users and support staff happy. You drop the connection to the table after "rollback" of data entries, thus preventing partial writes (cleanup after a faulty broadcast)
dim conx as...
True, Trudye, VB is not a "database" language. It is a powerful programming language that creates compiled and distributable front-end applications for all sorts of storage media. I've written VB6 applications using ADO to access massive enterprise-wide Oracle databases, smaller...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.