Recent content by petertickler

We have been running Continuous Protection Server (CPS) for a couple of months and I am beginning to wonder if it isn't causing problems. Users have been complaining of intermittent "Connection failure" messages when running desktop applications that connect to SQL server DBs (version 2000)...

Try using YearSpan.

I don't know, but I am surprised you are moving from ADO to BDE. It sounds like a step backwards to me.

Are you saying that you run the same query on different PCs, and one works OK, and the other doesn't? If so, have you checked that you have got the ADO connectivity installed on both PCs? In fact, what operating system are you running? Are you running the query from the second PC while the...

It is telling you that 'Interface_Installed' is a string which you are trying to match, not another field name in the table.

What's wrong with using Quickreport? I have used it for ages in various versions of delphi.

Try ... except ... " should work OK. However if you are running it from within the Delphi IDE, then I think it depends on how your debugger options (under Tools) are set. Try running the same piece of code as an application from the desktop, not from the IDE, and see what happens then. Peter

Hard to tell, but if I was you I would look at the data. Maybe there is something unexpected in the data - maybe a blank record at the beginning or two identical records that you haven't realised. Put in messages to examine the data within each record. Peter

Decimal isn't a standard Data Type in Delphi, and seems to be to be pretty old fashioned and relatively inefficient. In a sense, you are fortunate they supported in relation to 4.1! Glad my suggestion worked. Ta for the star.

I suggest you try changing the DataType from decimal to a Double.

This suggests to me that it may be something to do with your field names. Are you using names that are now reserved words, for example? Can you provide an example of the field names of tables that don't work? Peter

If you are using a query to read your data, then you need to use the First ... Next commands. For example: with myQuery do begin if active then close; Parameters.ParamByName('id').Value := My_ID; open; first; while not EOF do begin // do something with the current record...

Does your ADOConnection work OK? Can you open a simple ADOQuery against a table? What is your Operating System? It may be a question of upgrading your DB connectivity. Peter

I have opened up the package. When I compile or build it, it seems to be fine. But when I do a syntax check of the package, I get a message: [Fatal error] Bad file format: 'BPCComp98.dcp' Help!

I am trying to create a very simple component. I have used the Component wizard, but when I try to install the component (its ancestor type is TButton), I get the error message "[Fatal Error] dclusr.dpk(38): Bad file format: 'i:\delphi6_comps\bpccomps\BPCComp98.dcp'". BPCComp98 is a package...