Search results for query: *

thx Trevil for the input but this wont explain why on some machines and not on all. I will check what vladk has suggested.

hi, i have a app in VB6 that has few command control button on the UI. I have seen that when i load the program on some winXP machines, the button lose their actual place. I know they are placed in one specific order, still they just move places. I can go and load the same thing on another...

I am using Crystal Report 8.5 (Crystal report engine objecty lib cpeaut32.dll). I get "Unable to Open database error). The same code, same report does not works on some machines but works on others. There is no sub-report being called from this report. i m using fox pro6 as database, and...

hi, i observed that all the other rpts on this machine work all the fine but for this one. So that means MDAC or ODBC work just fine. I have checked all ttx file compatibilitties also but dont know what more to look at. any other ideas

i m using fox pro6 as database, and connecting to the rpt thru ODBC. I am passing a recordset in my app to the crystal rpt (CPEAUT32.dll) for it to view and print

hi I am using Crystal Report 8.5 (Crystal report engine objecty lib cpeaut32.dll). I get "Unable to Open database error). The same code, same report does not works on some machines but works on others. There is no sub-report being called from this report. Any ideas.??what can i check

hello r937 i worked as you had suggested..I am using the follpwing query Select sum(qtk.span) as Linqty , qth.qtnum, qtk.qtlin,sum(qtk.lnqty) as lnqty,qtl.idesc,qtk.plies,qtk.untot,qtk.ptype,(qth.csnam)as selectcust,cus.grpcd,(qtk.span) as span, (qth.qtalt) as ID from qth,cus,qtk, qtl where...

hello r937 1. i need sum a sum for each different value of qtk.span.. 2. Yes you are right as i have ommitted a qtl join condition by mistake I will work as you have suggested

hi, i have this query and when executed in mySQL query window throws error that "Big Query - Query not completely stored in memory". Also executed thru app, the program justs hangs. I have checked all indexes, they all look good. ---------------------------------------------------- Select...

when I follow the follwoing command (restore headeronly from disk='f:\sql\data\database.bak') I get all Nulls in the results window of the query analyser and under the Backupname column I get Incomplete entry. Does this indicates that the Bakup file was bad??

another thing that forgot to mention that my customer can restore the database at their end using the same file while I can not. Does it has something to do with users or access to SQL

hi, I used the following command to restore database but I still got the error. Any more ideas or suggestions. I made sure that the path is correct and the names of the log and mdf files are coorect using Restore FileListonly. "The media family on device 'F:\sql\Data\Database.Bak' is...

i did not find anything that says Match media name. Also how di i restore it using query analyser

1. I am restoring from a .bak file that my customer has sent to me. 2. this .bak file was created on a different server SQL2000 on win2k 3. Restore is being done when I do right click on databases, then All tasks and then Restore Database.

hi I am trying to restore a SQL database bak-up file and I get an error that Media family not correct error 42000. What could be the issue?? any ideas are welcome thx TA

hi..the following statement worked.. select cast(something as varchar (2000)),count(cast(something as varchar (2000))) from mytable group by cast(something as varchar (2000))

hi, i have this query that performs grouping.. select table.field1, table1.field2 from table1 group by field1, field2. field2 is a memo field so it does not allows grouping a memo field.. Is there a way I can workaround the situation. I am using VB6, SQL server 8.0

Also, the save involves direct insert commands..it seems that mySQL inserts are faster than SQL inserts.

i am using a server side cursor ..here is the snippet. mo_CnLib.CursorLocation = adUseServer

how can i find out if I am using cursor on SQL side. As far as VB app is concerned, the code is same ad I just change the DSn to talk to mySQL or SQL.