Zeoslib Portal

Here is my simple test case that shows failure when generators are created as a double quoted mixed case name... [syntax="delphi"] procedure TForm1.Button3Click(Sender: TObject); var ASequence: IZSequence; AStatement: IZStatement; begin ZeosLibDM.MainConnection.Connect; AStatement := ZeosL...

I need to be able to update more than one row in a result set before updates are applied. Is there a component in ZeosLib that will let me do this? If there isn't a component, is there a reason (other than time and effort) that this capability should not exist? For instance, would this capability re...

Mark you're right, that was my mistake. The solution is to pass a upper-cased name to the TZSequence object. When creating my objects i wasn't paying attention to case, and i wasn't double-quoting object names either. In other words i was relying on the db to be case insensitive. so it surprised me ...

GetNextValue does a case-sensitive comparison to determine the generator value... [syntax="delphi"] function TZInterbase6Sequence.GetNextValue: Int64; begin ... ResultSet := Statement.ExecuteQuery( 'SELECT GEN_ID(' + Name + ', ' + IntToStr(BlockSize) + ') ' + 'FROM rdb$generators ' + 'WHER...