Recent content by Nordyck

All you need is 2 fields. 1 in the BE (Version) and 1 in the FE (FE_Version) When the user opens the FE, the two version is compaired. If the two don't match then need to update the FE then have the FE kick off an update script. nordycki@hotmail.com

Not sure what your trying to do, but I would use binary for your days. This way, you an just OR it together to get the days you want. Sunday = 1000000 Monday = 0100000 etc. M,T,Th = 0110100 nordycki@hotmail.com

I'm getting this error: Msg 4866, Level 16, State 1, Line 1 The bulk load failed. The column is too long in the data file for row 1, column 52. Verify that the field terminator and row terminator are specified correctly. Msg 7399, Level 16, State 1, Line 1 The OLE DB provider "BULK" for linked...

Trying to convert this to oracle syntac Update G081_ELTNHA e set e.NHAPN = e1.PN inner join G081_ELTNHA e1 on (e.NHACEI = e.CEI and e.NHASN = e1.SN) Thanks, Dave nordycki@hotmail.com

thanks, that worked great. nordycki@hotmail.com

provide more clarification, depending upon your network permissions, the exe (written in vb6) file could be on the local PC, as in my case, or executed from the network. The file size <40kb. The FE (front end), captured the network logon ID for automatic logon. With this process, I also...

the code was written in vb6. When the user open the app (FE) he's automatically logged on via a hidden form when the app opens. a checkbox by his userid is automatically checked and date when he logs on. Then when he closes the app, he is automatically signs out and date cleared. On close of...

I tried a bat process and it didn't work reliably. I had to backup and compact the db every night, a trick I used when the last user closed the database (check the ldb file or keep track of who is logged on), it would kick off an exe file. The exe would then compact the db and create a zip...

I had the same problem with an app I worked on, one of the problem was in the code, there were bunch of recordsets being created through out the app. I had to track down all of the recordsets and close them. On rare occasions, I simply had to import everything into a new blank database and...

I'm attempting to build update.sql file that updates several tables with the same values. Update file is executed from a batch file. file: update.sql ------------------ dte date := systimestamp; st varchar2 := "test"; / update tbl1 set Source=st, ProcessDate=dte where ProcessDate is null; /...

What I'm trying to do is read a image file in (which works), and then rewrite it. The problem is in the rewriting it. I can't just copy it because I'll be doing some bit manipulation before it's written back out. Tried various stuff and it didn't work. Sub test Dim binfile As Variant...

Need some help converting this. Thanks in advance, Nordyck gm.ipcp.name = strcpy(&(gm.ipcp.name),(char*)AttrValue); //gm.ipcp.name = (char*)AttrValue; //error message --> cannot convert from 'char *' to 'char [96] nordycki@hotmail.com

Yea, it does sound like homework but it isn't. Last time I did anything like this it was over 10 years ago and not very good then. I get these error any idea what this crap means? --------------------Configuration: test - Win32 Debug-------------------- Linking... nafxcwd.lib(thrdcore.obj) ...

Does anyone have a working example of n-way b-tree written in vc++ 6.0? If so, can I get a copy of it. Each node could have max of 52 children. Thanks in advance Nordyck nordycki@hotmail.com

Paul, The simplist way would to create your backup mdb with code that when it's open, it automatically pulls the data from the other database. Use the task scheduler, to start the mdb at specified time. This will do your daily backups. Don't forget to compact on close. Otherwise the mdb...