Search results for query: *

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 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

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...

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, 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

hi I have 2 databases (the size are same). When I sue my VB program to save data to mysql, it is much faster than SQL server. I have checked all the indexes on the relevant tables but still slow. For a data that takes 2 sec to save in mySQL, it takes aound 8 seconds on SQL. Again, the sizes and...

hi, I have 15 tables that have NULLS entered in most of the records for 10 different fields in each of those tables. Is there a stored procedure I can make that would go in each of the record for each field and replace those nulls with 0. I have this stored procedure that does not replaces the...

hi, I have a table that has defaults defined for each column. How can i change the existing data in this table to be set as default where NULLs are present. Actually I just managed to set-up defaults for each column so any new data will be correct, now the question is to how to take care of the...

hi if anybody can help me with the syntax of stored procedure where it will set default for each column of a given table to a specfied value.

hi I would like to define defaults for a column in a table in vfp6.0 using VB. What is the syntax of the code that would define the defaults for the column using VB.

I have a program that calls an active X exe but for some reasons sometimes the activex exe when closed does not gets removed and still keeps running in the background or memory. So when i call the activex exe again, it says that I am running another instance and I have to go to task bar and...

Hi, Is there a way to get multiple inserts into the database, i have some issues regarding ADO.updatebatch and I am looking for some way to work around. I can use ADO.Update but it would be slow as it would do 1 records at a time. I am using VB6+VFP7 thx TA

hi i am having a weird issue. I have a code that runs well but then it fails on updatebatch command for no reason. It does not gives error also but stays therelike the machine hangs up. Can anybody give me some ideas as to what to do and how to solve this issue. I am using "rs.updatebatch"...

Hi I have this routine where I do recodrsed.update, I am using the following commands rs.Open sSQL, conn,adOpenKeyset, adLockBatchOptimistic After I add a new record to this recordset when I go for udpate using rs.updatebatch, the program hangs up. Most of the time the program works fine but...

hi Is there a way that when I set optionButton.value = 1 it should not fireup option_click event. th

hi Can we compress a recordset so that the time reqd to transport across the network is less.

Hi I have a appliction which does the query on foxpro 7 database on the server and gets the results back in the form of recordset isng ADO. now the data takes long time to get transported back to the client for ex. it takes around 20sec to execute the query but takes around 130 sec to...

hi i am looking for some guidance on how to make certain columns hide and unhide at run time. The user can hide/unhide them at their own choice, save it as a setting. I can handle the saving setting part but hide/unhide is not clear. thx for help

hi i am having a weird issue. I have a code that runs well but then it fails on updatebatch command for no reason. It does not gives error also but stays therelike the machine hangs up. Can anybody give me some ideas as to what to do and how to solve this issue. thx