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
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.