use FOR instead of table
Edward Koryagin
--- On Wed, 22/9/10, Jeremy Coulter jscoul...@gmail.com wrote:
From: Jeremy Coulter jscoul...@gmail.com
Subject: [DUG] Interbase Stored Proc
To: NZ Borland Developers Group - Delphi List delphi@delphi.org.nz
Received: Wednesday, 22 September, 2010, 9:32
Hi all.
I know a few of you out there work with Interbase so I thought I might ask
the following question here.
I want to create a stored procedure that creates a table. So I am doing :-
CREATE PROCEDURE MySP_ AS
begin
create table DAR_RESULTS
(
PATIENTIDchar(7),
TEST_NAMEvarchar(30),
Coulter
Sent: Wednesday, 22 September 2010 9:32 a.m.
To: NZ Borland Developers Group - Delphi List
Subject: [DUG] Interbase Stored Proc
Hi all.
I know a few of you out there work with Interbase so I thought I might ask
the following question here.
I want to create a stored procedure that creates
- Delphi List
*Subject:* [DUG] Interbase Stored Proc
Hi all.
I know a few of you out there work with Interbase so I thought I might ask
the following question here.
I want to create a stored procedure that creates a table. So I am doing :-
CREATE PROCEDURE MySP_ AS
begin
create table
Hi All.
I am just working thru converting a D2007 app to D2010.
Its taken me most of the moring to get updated controls, install them,
convert strings etc.etc. but this one has stumpted me.
I am inserting some data into a blob field in Interbase like so (or similar)
Sounds like a Unicode issue. The default string in D2010 is a unicode
string.
Can you use:
IBQuery1.ParamByName('blobby').AsString := 'blah blah blah';
?
Colin
On 4 March 2010 11:08, Jeremy Coulter jscoul...@gmail.com wrote:
Hi All.
I am just working thru converting a D2007 app to D2010.
well, the thing is, this IS a blob field not a string field. but I will give
it a try
Jeremy
On Thu, Mar 4, 2010 at 2:17 PM, Colin Johnsun colin.a...@gmail.com wrote:
Sounds like a Unicode issue. The default string in D2010 is a unicode
string.
Can you use:
Well alternatively, you can try passing in an AnsiString into your blob
field. I haven't tried it myself but it may be worth a go.
Colin
On 4 March 2010 12:21, Jeremy Coulter jscoul...@gmail.com wrote:
well, the thing is, this IS a blob field not a string field. but I will
give it a try
yeah I tried that and it didnt like it.
Jeremy
On Thu, Mar 4, 2010 at 2:36 PM, Colin Johnsun colin.a...@gmail.com wrote:
Well alternatively, you can try passing in an AnsiString into your blob
field. I haven't tried it myself but it may be worth a go.
Colin
On 4 March 2010 12:21, Jeremy
Use the new BytesOf functions in the SysUtils unit. TBytes is just an
array of TByte.
There is also a PlatformBytesOf function that you could use.
You may also want to investigate the TEncoding class while you are at it.
On Thu, Mar 4, 2010 at 11:08 AM, Jeremy Coulter jscoul...@gmail.com wrote:
Can we do
IBQuery1.ParamByName('blobby').Value := 'asdfdas';
Edward Koryagin
--- On Thu, 4/3/10, Jeremy North jeremy.no...@gmail.com wrote:
From: Jeremy North jeremy.no...@gmail.com
Subject: Re: [DUG] Interbase Blobs in Delphi 2010
To: NZ Borland Developers Group - Delphi List delphi
...@gmail.com wrote:
From: Jeremy North jeremy.no...@gmail.com
Subject: Re: [DUG] Interbase Blobs in Delphi 2010
To: NZ Borland Developers Group - Delphi List delphi@delphi.org.nz
Received: Thursday, 4 March, 2010, 3:00 PM
Use the new BytesOf functions in the
SysUtils unit. TBytes is just
...@yahoo.co.nzwrote:
Can we do
IBQuery1.ParamByName('blobby').Value := 'asdfdas';
Edward Koryagin
--- On Thu, 4/3/10, Jeremy North jeremy.no...@gmail.com wrote:
From: Jeremy North jeremy.no...@gmail.com
Subject: Re: [DUG] Interbase Blobs in Delphi 2010
To: NZ Borland Developers Group
Hi all,
Can someone tell me what are the different ODS versions for each
Interbase version please?
Thanks
Cheng Wei
Software Development Manager
FMI Research Ltd
P: +64 9 984 4917
F: +64 9 984 4993
M: +64 21 410 776
E: che...@fmi.co.nz
W: http://www.fmi.co.nz
Hi all.
I am using the IB Monitor control(Delphi 2007) to get the SQL that is being
executed by my app.
But what I want to know is, is there a way to trace what events are being
executed on the interbase server?
MSSQL has the SQL Trace tool, and I am wondering if there is a similar app
or
, and seasons greetings, hope it's all going well for you ;-)
Regards
Willie
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
Behalf Of Richard Vowles
Sent: Friday, 7 December 2007 5:23 p.m.
To: [EMAIL PROTECTED]; 'NZ Borland Developers Group - Delphi List'
Subject: RE: [DUG] InterBase
Ooops, sorry everybody. Please ignore that...
___
NZ Borland Developers Group - Delphi mailing list
Post: delphi@delphi.org.nz
Admin: http://delphi.org.nz/mailman/listinfo/delphi
Unsubscribe: send an email to [EMAIL PROTECTED] with Subject: unsubscribe
'
Subject: RE: [DUG] InterBase 7.1 desupported
Ooops, sorry everybody. Please ignore that...
!DSPAM:475f0694409474353130381!
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
Behalf Of Willie Juson
Sent: Wednesday, 12 December 2007 9:52 a.m.
To: 'NZ Borland
FYI,
http://support.codegear.com/article/34337
IB 7.1 *is* desupported. 7.5 will be desupported in Nov 2008.
Richard Vowles, Product Evangelist
Developers Inc Ltd
web. http://www.developers-inc.co.nz http://www.developers-inc.co.nz
ph. +64-9-3600231, mob. +64-275-467747, fax.
Dec 2007 13:26:51 +1300
Subject: [DUG] InterBase 7.1 desupported
FYI,
http://support.codegear.com/article/34337
[http://support.codegear.com/article/34337]
IB 7.1 *is* desupported. 7.5 will be desupported in
Nov 2008.
Richard
Vowles, Product EvangelistDevelopers
Inc Ltdweb
Subject: [DUG] InterBase 7.1 desupported
FYI,
http://support.codegear.com/article/34337
[http://support.codegear.com/article/34337]
IB 7.1 *is* desupported. 7.5 will be desupported in
Nov 2008.
Richard
Vowles, Product EvangelistDevelopers
Inc Ltdweb. http://www.developers
://www.actionthis.com task
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
Behalf Of Jeremy Coulter
Sent: Friday, 7 December 2007 2:46 p.m.
To: NZ Borland Developers Group - Delphi List
Subject: Re: [DUG] InterBase 7.1 desupported
actually, that link has been updated since the 3rd of this month
Hi All.
Is it true that come this month, December, that Interbase 7 moves into
de-support?
From the codegear website it shows it as in passive support, and also we
read that they give 12mths notice that a version goes into de-support, but
could not find any press releases or anything to say
@delphi.org.nz
Subject: [DUG] Interbase 7 de-support?
Hi All.
Is it true that come this month, December, that Interbase 7 moves into
de-support?
From the codegear website it shows it as in passive support, and also we
read that they give 12mths notice that a version goes into de-support, but
could
recipients of list delphi
Subject: [DUG]: Interbase/Firebird Forced Writes
Hi,
I know I can turn on and off Forced Writes (sychronous or aschronous
writes) in a database using the gfix utility, but does anyone
know how you
can tell what state the database is currently in from code?
I imagine
Hi,
I know I can turn on and off Forced Writes (sychronous or aschronous
writes) in a database using the gfix utility, but does anyone know how you
can tell what state the database is currently in from code?
I imagine there must be some SQL I can run that would give me this
information.
If I could
The usual topic im afraid...
I have the
following tables:MACHINEmachineidENTRYEntryIDMachineIDEntryDateQuantityStartQuantityEndQuantityJOBJobIDMachineIDJOBLINEJoblineIDJobIDJobDateJobLineCostI need to
select all entries between 2 dates, and all joblines between 2 dates, for every
machine
: [DUG]: Interbase SQL
The usual topic im afraid...
I have the following tables:
MACHINE
machineid
ENTRY
EntryID
MachineID
EntryDate
Quantity
StartQuantity
EndQuantity
JOB
JobID
MachineID
JOBLINE
JoblineID
JobID
JobDate
JobLineCost
I need to select all entries between 2 dates, and all joblines
', ENTRY.EntryDate, ENTRY.EntryID, ENTRY.MachineID,
FROM
ENTRY
WHERE
ENTRY.EntryDate BETWEEN Date1 AND Date2
- Original Message -
From: Tracey Maule [EMAIL PROTECTED]
To: Multiple recipients of list delphi [EMAIL PROTECTED]
Sent: Thursday, July 31, 2003 9:37 AM
Subject: [DUG]: Interbase SQL
these 'Sums' do you want them grouped by MachineID/ Ref
N
- Original Message -
From: Tracey Maule [EMAIL PROTECTED]
To: Multiple recipients of list delphi [EMAIL PROTECTED]
Sent: Thursday, July 31, 2003 10:51 AM
Subject: Re: [DUG]: Interbase SQL
is JOBLINE.Job Date ENTRY.EntryDate Indexed
PROTECTED]
Sent: Thursday, July 31, 2003 11:04 AM
Subject: Re: [DUG]: Interbase SQL
T
Well I'd index those fields as they are a primary selection criteria
(This is an oft overlooked part of SQL DB Management because they
will do virtually anything but the worst case as a linear search) also
]
To: Multiple recipients of list delphi [EMAIL PROTECTED]
Sent: Thursday, July 31, 2003 11:04 AM
Subject: Re: [DUG]: Interbase SQL
T
Well I'd index those fields as they are a primary selection criteria
(This is an oft overlooked part of SQL DB Management because they
will do virtually anything
ENTRY.EntryDate BETWEEN Date1 AND Date2
GROUP BY
MACHINE.MachineID
machine.ref
machine.machineid
- Original Message -
From: Tracey Maule [EMAIL PROTECTED]
To: Multiple recipients of list delphi [EMAIL PROTECTED]
Sent: Thursday, July 31, 2003 11:38 AM
Subject: Re: [DUG]: Interbase
of list delphi [EMAIL PROTECTED]
Sent: Thursday, July 31, 2003 12:11 PM
Subject: Re: [DUG]: Interbase SQL
Tracey
I'm not a IB expert but what you want can be got by
(also your most you could probably do with adding date to
the FK Index for Entry.MachineID)
SELECT
MACHINE.MachineID,
SUM
]
Sent: Thursday, July 31, 2003 12:38 PM
Subject: Re: [DUG]: Interbase SQL
wow that query takes forever...(26219ms)
but it still doesnt bring back all machines. I have one machine which has
no entries in entry, but has values in jobline.
I need to see these machines as well.
- Original
]
Sent: Thursday, July 31, 2003 11:04 AM
Subject: Re: [DUG]: Interbase SQL
T
Well I'd index those fields as they are a primary selection criteria
(This is an oft overlooked part of SQL DB Management because they
will do virtually anything but the worst case as a linear search) also
I'm currently using D5 pro with the interbase components provided.
I often get a bit confused with Borland's product names, and what these
products encompass. In D5, there are several Interbase components -
IBTable, IBQuery etc. Is this Interbase Express, or is that something
else? Regardless
Hi all.
We are currently in the process of converting some MSSQL DB's to
Interbase.
I know some stuff about interbase, but one of the other guys is
struggling.
Is there somewhere we can get some docs on Interbase, esp. supported SQL
statements etc.
Thanks, Jeremy
]
To: Multiple recipients of list delphi [EMAIL PROTECTED]
Sent: Wednesday, October 23, 2002 9:08 AM
Subject: [DUG]: Interbase
Hi all.
We are currently in the process of converting some MSSQL DB's to
Interbase.
I know some stuff about interbase, but one of the other guys is
struggling
thansk for that. Dont happen to know a URL for some doc?
Jeremy
-Original Message-
From: James Sugrue [EMAIL PROTECTED]
To: Multiple recipients of list delphi [EMAIL PROTECTED]
Date: Wed, 23 Oct 2002 09:28:52 +1300
Subject: Re: [DUG]: Interbase
I just did the opposite ;-)
Anyway
http://www.ibphoenix.com/main.nfs?a=ibphoenixpage=ibp_interbase_download#Do
cs
Under Beta Documentation
- Original Message -
From: vss [EMAIL PROTECTED]
To: Multiple recipients of list delphi [EMAIL PROTECTED]
Sent: Wednesday, October 23, 2002 9:28 AM
Subject: Re: [DUG]: Interbase
-
From: James Sugrue [EMAIL PROTECTED]
To: Multiple recipients of list delphi [EMAIL PROTECTED]
Date: Wed, 23 Oct 2002 09:47:43 +1300
Subject: Re: [DUG]: Interbase
http://www.ibphoenix.com/main.nfs?a=ibphoenixpage=ibp_interbase_downlo
ad#Do
cs
Under Beta Documentation
- Original
http://courseweb.xu.edu.ph/courses/cs54/ISQL-Tutorial.pdf
this one i use for most references
- Original Message -
From: vss [EMAIL PROTECTED]
To: Multiple recipients of list delphi [EMAIL PROTECTED]
Sent: Wednesday, October 23, 2002 9:08 AM
Subject: [DUG]: Interbase
Hi all.
We
Thanks for that Tracey. I forwarded it onto the guy who needs it.
Jeremy
-Original Message-
From: Tracey Maule [EMAIL PROTECTED]
To: Multiple recipients of list delphi [EMAIL PROTECTED]
Date: Wed, 23 Oct 2002 10:58:42 +1300
Subject: Re: [DUG]: Interbase
http://courseweb.xu.edu.ph
SMSS Ltd.
PM - Original Message -
PM From: Myles Penlington
PM To: Multiple recipients of list delphi
PM Sent: Wednesday, October 02, 2002 3:39 PM
PM Subject: RE: [DUG]: Interbase
PM Only problem I ever had was that the entry was missing from the services file -
the service
G'Day,
I know this is not strictly Delphi
but...
[I am subscribed to the Interbase list - but I have
never seen a posting]
I have been lumbered with the task of upgrading IB
5.6 to 6.0 for our Delphi Apps.
I have installed Interbase 6.0 but cannot get the
Interbase guardian (Service) to
PROTECTED]]Sent: Wednesday, 2 October 2002 3:37
p.m.To: Multiple recipients of list delphiSubject:
[DUG]: Interbase
G'Day,
I know this is not strictly Delphi
but...
[I am subscribed to the Interbase list - but I
have never seen a posting]
I have been lumbered with the task
Paul McKenzieAnalyst ProgrammerSMSS Ltd.
- Original Message -
From:
Myles Penlington
To: Multiple recipients of list delphi
Sent: Wednesday, October 02, 2002 3:39
PM
Subject: RE: [DUG]: Interbase
Only
problem I ever had was that the entry was missing fr
I have to convert an Interbase 6.0 DB to MS SQL Server 7.0. Does anyone know
of any tools that would do this ?
---
New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
Website:
If there's an ODBC (or OLE DB) driver for Interbase you could try using Data
Transformation Services (DTS) in SQL Server.
/p
---
New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
, 2002 8:14 AM
Subject: [DUG]: Interbase to SQL Server
I have to convert an Interbase 6.0 DB to MS SQL Server 7.0. Does anyone
know
of any tools that would do this ?
--
-
New Zealand Delphi Users group - Delphi List
:\somedirectorytosomedatabase\somedatabase.gdb
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On
Behalf Of James Sugrue
Sent: Thursday, 19 September 2002 13:48
To: Multiple recipients of list delphi
Subject: RE: [DUG]: Interbase and Citrix Environment
I tried doing a network map here
Not quite sure if you have solved this yet but we uses citrix
extensively at Satara for the Packhouse on the WAN
Intebease and the database sit on a dedicated DB Server
that is address by all the accessing station wether on the
lan or citrix
then Conection String for every one including
[mailto:[EMAIL PROTECTED]]
Sent: Thursday, 19 September 2002 4:59
To: Multiple recipients of list delphi
Subject: RE: RE: [DUG]: Interbase and Citrix Environment
James Sugrue wrote on Thursday, 19 September 2002 4:30 p.m.:
Basically because they're f^ck wits. Its as much political as
anything else
Message-
From: Max Nilson [mailto:[EMAIL PROTECTED]]
Sent: Thursday, 19 September 2002 5:05
To: Multiple recipients of list delphi
Subject: RE: [DUG]: Interbase and Citrix Environment
Kyley Harris said:
I believe it will need to reside on the same machine.
Most certainly the data base (tat
To: Multiple recipients of list delphi
Subject: RE: RE: [DUG]: Interbase and Citrix Environment
Exactly. Problem with IT in our company is anyone good get p*ssed off
with bullsh^t like this which happens all the time, and leaves. Leaving
deadwood and dipsh^ts running the place.
Major problem is we
they take on.
-Original Message-
From: Jeremy Coulter [mailto:[EMAIL PROTECTED]]
Sent: Friday, 20 September 2002 8:22
To: Multiple recipients of list delphi
Subject: RE: RE: [DUG]: Interbase and Citrix Environment
Hmmm...I am looking for/need a Delphi job..should I just pretend I
didn't
Does anyone have any experience installing Interbase on a citrix environment
?
I have an app I have developed that when finished will need to be run from
Citrix.
The network boffins want to do the following :
Install the Interbase Server on a Citrix Server.
Have the executable on this server.
delphi
Subject: [DUG]: Interbase and Citrix Environment
Does anyone have any experience installing Interbase on a citrix
environment ?
I have an app I have developed that when finished will need to be run
from Citrix.
The network boffins want to do the following :
Install the Interbase Server
: Kyley Harris [mailto:[EMAIL PROTECTED]]
Sent: Thursday, 19 September 2002 3:44
To: Multiple recipients of list delphi
Subject: RE: [DUG]: Interbase and Citrix Environment
I believe it will need to reside on the same machine. Or possible with a
network drive map you might trick interbase. One
James Sugrue wrote on Thursday, 19 September 2002 3:35 p.m.:
The network boffins want to do the following :
Install the Interbase Server on a Citrix Server.
Have the executable on this server.
Store the actual database file on a separate machine.
Why do they want to do it this way? Surely
Basically because they're f^ck wits. Its as much political as anything else.
-Original Message-
From: Paul Eggleton [mailto:[EMAIL PROTECTED]]
Sent: Thursday, 19 September 2002 4:28
To: Multiple recipients of list delphi
Subject: RE: [DUG]: Interbase and Citrix Environment
James
: RE: [DUG]: Interbase and Citrix Environment
Basically because they're f^ck wits. Its as much political as anything
else.
-Original Message-
From: Paul Eggleton [mailto:[EMAIL PROTECTED]]
Sent: Thursday, 19 September 2002 4:28
To: Multiple recipients of list delphi
Subject: RE
James Sugrue wrote on Thursday, 19 September 2002 4:30 p.m.:
Basically because they're f^ck wits. Its as much political as
anything else.
Isn't it always :(
The problem in many cases seems to be that many sysadmins and IT staff
don't start out as computer enthusiasts so they have only a
Kyley Harris said:
I believe it will need to reside on the same machine.
Most certainly the data base (tat is GDB files and friends) must reside on
the same machine as the IB/FB server.
Or possible with a network drive map you might trick interbase.
This is explicitly disallowed by the
September 2001 9:24 a.m.
To: Multiple recipients of list delphi
Subject: [DUG]: Interbase X SQL Server
Hello all,
This is my debut in [EMAIL PROTECTED] !
Although the yesterday disaster, I have to work...
And unfortunately I have a very serious problem on
my work:
I work maintaining
2001 22:56
To: Multiple recipients of list delphi
Subject: RE: [DUG]: Interbase X SQL Server
The hstmt error is endemic to odbc. It is caused by having more than one
active query at a time (an active query is one which has not retrieved all
it's rows).
To mitigate this try the following
Try Interbase Workbench www.interbaseworkbench.com It's an excellent tool
with loads of good features.
Cheers,
Scott.
-Original Message-
From: James Sugrue [mailto:[EMAIL PROTECTED]]
Sent: Friday, 14 September 2001 9:33 a.m.
To: Multiple recipients of list delphi
Subject: [DUG
On 14 Sep 2001, at 9:33, James Sugrue wrote:
We use a Program called IBAdmin for this stuff , lets us do lots of cool stuff but we
are
verycautious not to use it on a live database as ocassional it lets you do changes to
triggers and
procedures it shouldnt and can corupt the DB but it
Cheers Guys,
Will give both a look.
-Original Message-
From: James Sugrue [mailto:[EMAIL PROTECTED]]
Sent: Friday, 14 September 2001 09:33
To: Multiple recipients of list delphi
Subject: [DUG]: Interbase Desktop
Morning all,
Does anyone know of a program that allows the visual
try quickdesk, it's quite good
http://www.ems-hitech.com/quickdesk/
Sandeep
Software Developer
CFL
[EMAIL PROTECTED]
http://www.cfl.co.nz
---
New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
Subject: Re: [DUG]: Interbase Desktop
try quickdesk, it's quite good
http://www.ems-hitech.com/quickdesk/
Sandeep
Software Developer
CFL
[EMAIL PROTECTED]
http://www.cfl.co.nz
---
New Zealand Delphi Users group
PROTECTED]
Sent: Friday, September 14, 2001 9:58 AM
Subject: Re: [DUG]: Interbase Desktop
On 14 Sep 2001, at 9:33, James Sugrue wrote:
We use a Program called IBAdmin for this stuff , lets us do lots of cool
stuff but we are
verycautious not to use it on a live database as ocassional it lets
[EMAIL PROTECTED]
Sent: Friday, September 14, 2001 9:33 AM
Subject: [DUG]: Interbase Desktop
Morning all,
Does anyone know of a program that allows the visual creation of tables
etc
in Interbase 6.0, ala Interbase Desktop, or something similar to Database
Desktop for Paradox ?
Cheers
Hello all,
This is my debut in [EMAIL PROTECTED] !
Although the yesterday disaster, I have to work...
And unfortunately I have a very serious problem on
my work:
I work maintaining and raising a big system
developed in Delphi 4 Client/Server.
This system was made by another person
-
From: Paul Mostek [EMAIL PROTECTED]
To: Multiple recipients of list delphi [EMAIL PROTECTED]
Sent: Thursday, September 13, 2001 9:24 AM
Subject: [DUG]: Interbase X SQL Server
Hello all,
This is my debut in [EMAIL PROTECTED] !
Although the yesterday disaster, I have to work
for American date formats, but I have found that 'MMDD HH:MM:SS'
appears to work regardless of the SQL 7 settings.
Stephen
-Original Message-
From: Paul Mostek [mailto:[EMAIL PROTECTED]]
Sent: Thursday, 13 September 2001 9:24 a.m.
To: Multiple recipients of list delphi
Subject: [DUG
Just a question really.
Do you use Interbase? Do you also spend a bunch of time trying to figure
out which indicies to create? and are they only to support performance in
your stored procs? Do you wish you could use cursors in your stored procs?
Would you like to be able to use a stored proc
Hi all. my boss just
asked me about interbase licensesIB 6 this is.
Am I right in
thinking that you dont have to buy licenses for it now ? or whats the
sroty...its been so long since I used it, I cant remember.
Cheers Jeremy
Coulter
delphiSubject:
[DUG]: Interbase
Hi all. my boss
just asked me about interbase licensesIB 6 this is.
Am I right in
thinking that you dont have to buy licenses for it now ? or whats the
sroty...its been so long since I used it, I cant remember.
Cheers Jeremy
Coulter
Oracle has sqlldr which provides ultrafast bulk import of data into the database by
shutting down logging, transactions, dropping contraints and indices etc. Even if
you do these manually, SQLLDR still runs orders of magnitude faster. It moves
data into tables faster than I can copy file over
My stored procedure (below) wont work. When I call execproc I get either a
parameter or type mismatch or I am told there is no Params[0] - the return
value. The generator it uses has not incremented.
I have an IB Insert TRigger that correctly uses the generator to fill in a
Null field value when
On 30 May 2001, at 9:21, James Low wrote:
My stored procedure (below) wont work. When I call execproc I get either a
parameter or type mismatch or I am told there is no Params[0] - the return
value. The generator it uses has not incremented.
I have an IB Insert TRigger that correctly uses
HTH
Cheng
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On
Behalf Of James Low
Sent: Wednesday, 30 May 2001 09:21
To: Multiple recipients of list delphi
Subject: [DUG]: Interbase/Delphi Stored Procedure
My stored procedure (below) wont work. When I call
CREATE PROCEDURE PRO_GETSLPRTY
RETURNS (ID_SLPRTY INTEGER)
AS
BEGIN
ID_SLPRTY = gen_id(GEN_SLPRTY, 1);
um, dont you need a
SUSPEND;
right about here? Or is that just for ones you execute with
select * from PRO_GETSLPRTY
??
Thats because u r trying to pass a input parameter
Nic Wise [EMAIL PROTECTED] wrote on 30/05/2001 09:46:33:
CREATE PROCEDURE PRO_GETSLPRTY
RETURNS (ID_SLPRTY INTEGER)
AS
BEGIN
ID_SLPRTY = gen_id(GEN_SLPRTY, 1);
um, dont you need a
SUSPEND;
right about here? Or is that just for ones you execute with
select * from PRO_GETSLPRTY
recipients of list delphi
Subject: Re: [DUG]: Interbase/Delphi Stored Procedure
On 30 May 2001, at 9:21, James Low wrote:
My stored procedure (below) wont work. When I call execproc I get either a
parameter or type mismatch or I am told there is no Params[0] - the return
value. The generator it uses
PROTECTED]
To: "Multiple recipients of list delphi" [EMAIL PROTECTED]
Sent: Wednesday, December 20, 2000 4:10 PM
Subject: Re: [DUG]: Interbase ASP.
www.interbase.com has one for ib5.6 that also works with IB6.0 in dialect
1
There is a (slow) one at easysoft.com (I'm told) for 6.0 only
There
Ahem...
I could either turn the other cheek, totally ignore this or liven up the
list for christmas - what should it be
1/ My Name is Neven
Sorry about that, it was unintentional, and I meant no offence by it.
2/
In my limited circle of developer friends I know of 2 (probably 3
On Tue, 19 Dec 2000, Carl Reynolds wrote:
when DBExpress (D6) comes out we'll start switching over to that (ie. new
and improved, more generic weird bugginess :-).
I wonder, being that DBExpress is the CLX based components, does you're
entire project have to be ported to CLX in order to use
Does anyone know of published comparisons of Interbase 6 with other
databases?
I have read of a report done by Xperts Inc in August 2000 comparing
Postgress, My SQL, Interbase doing simulated transactions for 100
simultaneous users. In that test Postgres made over 1070 transactions per
sec with
From: Mark Derricutt [mailto:[EMAIL PROTECTED]]
when DBExpress (D6) comes out we'll start switching over to that (ie.
new
and improved, more generic weird bugginess :-).
I wonder, being that DBExpress is the CLX based components, does you're
entire project have to be ported to CLX in
No!! At least that's not what I've gleaned about CLX, which is: CLX is a
set of cross-platform components designed to replace the Windows component
set. If you want to run on Linux, you obviously can't use the Windows
components, so you're likely to use CLX components.
Correct, mostly.
Can someone point me to some resources to do with accessing an interbase
database via ASP...Are there ODBC drivers?
Cheers,
Matt.
---
New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
Can someone point me to some resources to do with accessing an interbase
database via ASP...Are there ODBC drivers?
Cheers,
Matt.
---
New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
: "Matthew Comb" [EMAIL PROTECTED]
To: "Multiple recipients of list delphi" [EMAIL PROTECTED]
Sent: Wednesday, December 20, 2000 5:03 PM
Subject: [DUG]: Interbase ASP.
Can someone point me to some resources to do with accessing an interbase
database via ASP...Are there OD
Sorry I can't let this pass.
Nevan wrote...
So unfortunately does MSDE - and don't dump that small footprint dogma
on me because at 64Mb ram at $75 and 15Gb disk at $200 it is irrelevant.
Does it also, like it OS brethren, spend all it's idle time looking for
available resources to hog?
Hi
The following article describes how to lock the record.
http://www.ibphoenix.com/doc0844.html
I tried that (I execute an update query on BeforeEdit event) but it
doesn't seem to work.
Sandeep.
---
New Zealand
Willie
Three things
1/ My Name is Neven
2/
In my limited circle of developer friends I know of 2 (probably 3
actually -
none of which are called Nevan or Nic) that have worked with both and
they
all prefer IB after their experiences.
This is totally heresay, when you have some knowledge
world is a nail"
Neven
- Original Message -
From: Sandeep [EMAIL PROTECTED]
To: Multiple recipients of list delphi [EMAIL PROTECTED]
Sent: Tuesday, 19 December 2000 09:05
Subject: Re: [DUG]: Interbase
Hi
The following article describes how to lock the record.
http://www.ibp
1 - 100 of 296 matches
Mail list logo