If you are using ASA, your trigger will look something like this:
create trigger tbi_DefaultMyTableFK
before insert on MyTable
referencing NEW as new_rows
for each row
begin
if MyFKField is null then
//logic to set FKField default value...
select max(PKField)
into...
You don't need to select the current date.
If you use ASE, use this...
...
where date_index = Today(*)
If you use ASA, you can use Today(*) as above, or you can use Current Date, like this:
...
where date_index = Current Date
If the comparison you are performing is in Crystal Reports, then you can use the Crystal Reports Date function:
Date( {datetime expression} ).
If you are trying to do this in ASA, ASA has a similar Date function.
ASE may also support a similar function but I don't know for sure as I haven't...
Using AColumn LIKE 'SOME TEXT%' is interpreted by the parser into the following operation which can be nicely optimized if the column you use is indexed:
AColumn >= 'SOME TEXT' AND AColumn <= 'SOME TEXT' + "CHAR"(255)
The query parser is smart enough to recognize that anything...
You need to install ASA Server on the server. Each workstation connecting to the database will need to use an ASA Client.
Putting the database in a shared folder is not necessary (and doesn't help anything) as the ASA Server provides all connectivity to the database. That's the way...
Actually, it is a 32-bit app. They normally use BDE 3.50, but we have been able to run it on the more recent 4.5.1.4. This problem just cropped up after we migrated our product to Delphi 5, in which the BDE isn't backward compatible.
How do you run something in its own memory space??? I mean...
This implies that you are running two BDE versions that are compatible. For example, they are both 5.x or later.
Delphi 5 shipped with BDE 5.x. This version of the BDE was heavily documented by Borland to NOT be backward compatible. In fact, migrating our source code from D3 to D5 would have...
The application using the older BDE isn't ours. We don't have the source code. So we cannot recompile it.
Even if we did have the source code, it was developed in Turbo C++ (predecessor to C++ Builder)... not Delphi.
Just to give you an idea of how old this app is, it doesn't even use...
Unfortunately, this does not address the problem.
Each program requires a different version of the BDE (not just a different alias).
One requires BDE version 4.5.1.4
The other requires BDE version 5.1.0.4.
All suggestions are appreciated.
We have two separate applications that both need to run at the same time on the same workstation. Each application uses a different version of the Borland Database Engine (BDE). The two BDE versions are incompatible. Does anyone know how to configure a system to allow both BDE versions to run...
I believe INPUT is a command that is exclusive to ISQL.
Adaptive Server Anywhere supports INPUT in ISQL, but also has a LOAD TABLE statement that will work in SQL commands issued by a client app, stored procedure, or trigger.
If you are using Adaptive Server Enterprise, see if it supports the...
Using the OnMouseDown event to start the dragging operation is incorrect, since any kind of mouse click could trigger the drag operation. You cannot really identify the mouse operation as drag-and-drop until after the user, still holding the mouse button down, moves the mouse a minimum distance...
A quick and dirty way of doing this is to put the second TTreeView control inside a TPanel so that the vertical scroll bar is clipped by the TPanel container control. Be sure to set the TPanel.Locked property to True to disable its OLE functionality. Manipulate the TPanel's border properties as...
It's true that the caption of a check box is difficult to control. One solution is to NOT use the check box caption, but use a TLabel instead (as it gives you more control).
Otherwise, you can use your form's canvas to calculate the width of the text you are displaying...
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.