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!
-
Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
How do I make an field that is autoincremental in Interbase?
I would like to suggest one change to svanels suggestion, just in case ID already has been give a value by the client app ;) create trigger CLIENTinsert for CLIENTS before insert position 0 as begin IF (NEW.CLIENTID is null) then NEW.CLIENTID = gen_id(client_number_gen,1); end- Pamal
- Post #4
- Forum: Embarcadero: InterBase
-
extract string
Martin, try this. Drop a button and an editbox on a form and try the following code. type DelimSet = set of Char; function WordPos(N : Integer ; S : string; Delims : DelimSet) : Integer ; var ii,iLength,iCount : Integer; begin Result := 0; { default } iLength := Length(S); iCount := 0...- Pamal
- Post #3
- Forum: Embarcadero: Delphi
