Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

autofill on indexes when inserting records

Status
Not open for further replies.
Madbull

Madbull

IS-IT--Management
May 3, 2005
26
BE
Hi all,

I'm trying to insert records into an informix DB with a VB6 program through ODBC connection.
The problem is informix will return an error if i only fill in the fields and not the indexes...The problem is the indexes are build in a way i don't know with bizarre caracters in it and i was wondering if there is not a command or a parameter t oset so when you insert a record,informix takes care of filling these indexes...

Regards,
 
Sort by date Sort by votes
You mean a SERIAL column ?
If so, simply use a 0 (zero) to fill it.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

tuccero
  • Locked
  • Question
onstat -g ses returns "Changing data structure forced command termination"
Replies
1
Views
529
tuccero
tuccero
kray4660
  • Locked
  • Question
Trying to do a count on logged in users
Replies
1
Views
364
kray4660
kray4660
evgeniosc
  • Locked
  • Question
Copy rows as they inserted on a replica table using trigger
Replies
0
Views
295
evgeniosc
evgeniosc
aft5425
  • Locked
  • Question
help using dbload command utility; substitute values when i found spaces
Replies
0
Views
233
aft5425
aft5425
aft5425
  • Locked
  • Question
get records with distinct phone numbers only
Replies
2
Views
242
aft5425
aft5425

Part and Inventory Search

Sponsor

Back
Top