Search results for query: *

ok..The stored procedure looks scary for me. It might take some time but i'll be back with you. Thanks. I really appreciate your help :)

Thanks again. You really helped and i learned a lot from you. As of now, i'll try to write a stored procedure that will prevent the error from happening again. I haven't done it before but i'll try it. Btw, do you recommend any good reading materials this? Thank you.

Hi gmmastros: I tested the updated program and yes it is very fast now. Thanks again. I'm just curious will the "Error: Cannot insert duplicate key row in object 'package_label' with unique index 'description_index" still exist if two computers will be running the program and updating the...

I religiously followed your advise earlier. Thanks again. I'll keep you posted when i test the application in the site.

Yes. It makes sense. Forgive me for being so ignorant but isn't it INT data type has max length of 4. Dont you think my application will exceed the maximum value allowable for an INT? Right now, the very last value of det_description is 24480.

Hi gmmastros: I changed the det_description data type from nvarchar into numeric (sql). Is it right? It is working and faster. I still have to test the program in the site and i'll update you asap. Thanks.

i added one record and the resulting det_description = 10000 but when i checked all records in the dbase the very last record has det_desciption = 24414. Thus, the record i added should be 24415 Btw, it was faster now with the modifications you gave me. Thanks

ok..i'll try it and i'll update you Thanks again

Hi gmmastros: First of all thank you so much for the help. I really need this to be solved. You are right, inserting and then printing 10 rows is very slow which is the main problem right now besides the indexing. The original code cmdSave_click: Dim num, lastnum As Integer Let num = 0 Do...

Error: Cannot insert duplicate key row in object 'table1' with unique index 'description_index' My dbase is indexed. I encounter this error everytime i use two computers. I want to get rid of this error maybe just inform the PC2 that the dbase is being used and PC2 can save records after...

I can insert approx. 1-10 records everytime i click the Save button. Thanks for the reminder regarding when using INSERT. Since i'm using INSERT, is there a way to lock the sql dbase while the other pc is inserting/adding records? Or at least a inform the other user (from PC2) that the dbase...

Please help. I have a VB application using sql dbase. The application is installed in two computers. I am having problems when the 2nd computer is updating the dbase and/or both computer accessing the dbase. Do i need to lock the sql dbase? Please help on how to do this. Currently, I have...

Hi LB: i did what you have advised and it works great. Thanks

I have report which has columns: Shipment WorkDays Shipment/Diem 9 22 0.41 10 20 0.50 3 22 0.14 5 21 0.24 To calculate shipment/Diem column i used the formula -- Count...