October 25, 2000

Trigger for Updating the Table of the Trigger

Question: I would like it that every time I insert a row in table A, another row of the same table must be updated according to the values of the row I’m inserting. What’s the best way to do this? It’s impossible for me to do it with triggers?to update

GetPrimaryDCName

Question: I’m trying to get the PDC name for a domain on my network using the following code. It works fine within the VB IDE, but the moment I compile it and run it as an executable, it errors out with either NERR_DCNotFound(2453): Could not find domain controller for this

NetUserGetInfo – API Call

Question: I am using “NetUserGetInfo” API call to get the NT user profile. I use: typedef struct _USER_INFO_3 How can I parse the “usri3_flags” member in detail? Answer: Use this: Option ExplicitPrivate Const UserInfo1 As Long = 1&Private Type USER_INFO_1 usri1_name As Long usri1_password As Long usri1_password_age As Long usri1_priv

Maximum Number of Columns Allowed

Question: What is the maximum number of columns allowed in an Informix table? Answer: For Informix 7.3X, the maximum number of columns in a table is 2,767.

Migrating from Informix SQL to Informix Windows NT

Question: Is it possible to migrate from Informix SQL to Informix for Windows NT? Answer: Yes. Informix for Windows NT is now on version 7.31. This has the exact same functionality as 7.31 for UNIX. You won’t be able to use the byte-level dumps/restores of tbunload or onunload, but you

Changing the Environment Inside a Program

Question: How do I change the environment inside a program (filename.4gl)? Example: setenv TBCONFIG $tbconfig.01 Answer: I don’t think you can do it. If you’re running a 4gl program, you are already connected to the database. Any changes you make to the tbconfig file will take place only after bouncing