Re: [DUG] Interbase Stored Proc

use FOR instead of table Edward Koryagin --- On Wed, 22/9/10, Jeremy Coulter wrote: From: Jeremy Coulter Subject: [DUG] Interbase Stored Proc To: "NZ Borland Developers Group - Delphi List" Received: Wednesday, 22 September, 2010, 9:32 AM Hi all. I know a few of you out there

Re: [DUG] Interbase Stored Proc

> *From:* delphi-boun...@delphi.org.nz [mailto:delphi-boun...@delphi.org.nz] > *On Behalf Of *Jeremy Coulter > *Sent:* Wednesday, 22 September 2010 9:32 a.m. > *To:* NZ Borland Developers Group - Delphi List > *Subject:* [DUG] Interbase Stored Proc > > > > Hi all. >

Re: [DUG] Interbase Stored Proc

hi-boun...@delphi.org.nz] On Behalf Of Jeremy 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

[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 DAR_RESULTS ( PATIENTIDchar(7), TEST_NAMEvarchar(30), W

Re: [DUG] Interbase Blobs in Delphi 2010

agin wrote: > >> Can we do >> >> IBQuery1.ParamByName('blobby').Value := 'asdfdas'; >> >> Edward Koryagin >> >> >> --- On Thu, 4/3/10, Jeremy North wrote: >> >> > From: Jeremy North >> > Subject: Re: [D

Re: [DUG] Interbase Blobs in Delphi 2010

Thu, 4/3/10, Jeremy North wrote: > > > From: Jeremy North > > Subject: Re: [DUG] Interbase Blobs in Delphi 2010 > > To: "NZ Borland Developers Group - Delphi List" > > Received: Thursday, 4 March, 2010, 3:00 PM > > Use the new BytesOf functions in the > >

Re: [DUG] Interbase Blobs in Delphi 2010

Can we do IBQuery1.ParamByName('blobby').Value := 'asdfdas'; Edward Koryagin --- On Thu, 4/3/10, Jeremy North wrote: > From: Jeremy North > Subject: Re: [DUG] Interbase Blobs in Delphi 2010 > To: "NZ Borland Developers Group - Delphi List" > Receiv

Re: [DUG] Interbase Blobs in Delphi 2010

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 wrote: > Hi All. > I am ju

Re: [DUG] Interbase Blobs in Delphi 2010

yeah I tried that and it didnt like it. Jeremy On Thu, Mar 4, 2010 at 2:36 PM, Colin Johnsun 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 Coulter wrot

Re: [DUG] Interbase Blobs in Delphi 2010

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 wrote: > well, the thing is, this IS a blob field not a string field. but I will > give it a try > > Jeremy > > > On Thu

Re: [DUG] Interbase Blobs in Delphi 2010

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 wrote: > Sounds like a Unicode issue. The default string in D2010 is a unicode > string. > > Can you use: > > IBQuery1.ParamByName('blobby').AsString := 'bl

Re: [DUG] Interbase Blobs in Delphi 2010

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 wrote: > Hi All. > I am just working thru converting a D2007 app to D2010. > Its taken me most

[DUG] Interbase Blobs in Delphi 2010

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) IBQuery1.ParamByName('blobby')

[DUG] [INTERBASE] - ODS version for variour IB versions

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

[DUG] Interbase event Tracing

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 control

RE: [DUG] InterBase 7.1 desupported

List' 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: &

RE: [DUG] InterBase 7.1 desupported

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

RE: [DUG] InterBase 7.1 desupported

, 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 7.1 desupported

<http://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

Re: [DUG] InterBase 7.1 desupported

actually, that link has been updated since the 3rd of this monthmaybe we prompted them to update it :-) Jeremy -Original Message- From: "Richard Vowles" <[EMAIL PROTECTED]> To: "'NZ Borland Developers Group - Delphi List'" Date: Fri, 7 De

Re: [DUG] InterBase 7.1 desupported

27;" Date: Fri, 7 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 E

[DUG] InterBase 7.1 desupported

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 ph. +64-9-3600231, mob. +64-275-467747, fax. +64-9-3

RE: [DUG] Interbase 7 de-support?

46 a.m. To: delphi@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

[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 not find any press releases or anything to say thi

RE: [DUG]: Interbase/Firebird Forced Writes

> To: Multiple 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 tel

[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 there must be some SQL I can run that would give me this information. If I coul

Re: [DUG]: Interbase SQL

achineid > WHERE > ENTRY.EntryDate BETWEEN '01/01/03' AND '07/01/03' > group by machine.ref > > > > - Original Message - > From: "Neven MacEwan" <[EMAIL PROTECTED]> > To: "Multiple recipients of list delphi" <[EMA

Re: [DUG]: Interbase SQL

ipients of list delphi" <[EMAIL PROTECTED]> 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

Re: [DUG]: Interbase SQL

t;Multiple recipients 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

Re: [DUG]: Interbase SQL

> Sent: Thursday, July 31, 2003 11:38 AM Subject: Re: [DUG]: Interbase SQL > ok, I was fibbing a little... i had an index on jobline but none on entry... > Fixed that now (winking at the original developer) > > yes i will want these records grouped by machine. > > > >

Re: [DUG]: Interbase SQL

iginal Message - From: "Neven MacEwan" <[EMAIL PROTECTED]> 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

Re: [DUG]: Interbase SQL

pients 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

Re: [DUG]: Interbase SQL

x27; All 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 Subjec

Re: [DUG]: Interbase SQL

;[EMAIL PROTECTED]> > To: "Multiple recipients of list delphi" <[EMAIL PROTECTED]> > Sent: Thursday, July 31, 2003 9:37 AM > Subject: [DUG]: Interbase SQL > > > The usual topic im afraid... > I have the following tables: > > MACHINE > machineid > &

Re: [DUG]: Interbase SQL

hi" <[EMAIL PROTECTED]> Sent: Thursday, July 31, 2003 9:37 AM Subject: [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 Jo

[DUG]: Interbase SQL

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 wh

[DUG]: Interbase, Kylix and D7

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 o

Re: [DUG]: Interbase

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: [DU

Re: [DUG]: Interbase

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 Subj

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=ibphoenix&page=ibp_interbase_downlo > ad#Do &g

Re: [DUG]: Interbase

http://www.ibphoenix.com/main.nfs?a=ibphoenix&page=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:

Re: [DUG]: Interbase

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 >

Re: [DUG]: Interbase

TED]> 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 t

[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. Is there somewhere we can get some docs on Interbase, esp. supported SQL statements etc. Thanks, Jeremy -

Re: [DUG]: Interbase

Key being used :-( RegardsPaul McKenzieAnalyst ProgrammerSMSS Ltd. - Original Message - From: Paul McKenzie To: Multiple recipients of list delphi Sent: Wednesday, October 02, 2002 3:53 PM Subject: Re: [DUG]: Interbase Just had a look (ok just discovered that

Re[2]: [DUG]: Interbase

53" PM> Regards PM> Paul McKenzie PM> Analyst Programmer PM> 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

Re: [DUG]: Interbase

"   RegardsPaul 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

RE: [DUG]: Interbase

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

[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 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) t

Re: [DUG]: Interbase to SQL Server

MAIL PROTECTED]> Sent: Monday, September 23, 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 ? > -- - >

RE: [DUG]: Interbase to SQL Server

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] Website:

[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 - [EMAIL PROTECTED] Website: http://www.delp

RE: RE: [DUG]: Interbase and Citrix Environment

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 d

RE: RE: [DUG]: Interbase and Citrix Environment

06 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

RE: [DUG]: Interbase and Citrix Environment

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 b

RE: RE: [DUG]: Interbase and Citrix Environment

From: Paul Eggleton [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

Re: [DUG]: Interbase and Citrix Environment

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 citrix

RE: [DUG]: Interbase and Citrix Environment

ie localhost:c:\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 networ

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 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 IB/

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. > 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

Re: [DUG]: Interbase and Citrix Environment

Thursday, September 19, 2002 4:29 PM Subject: 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

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: [DUG]: Interbase and Citrix Environment

RE: [DUG]: Interbase and Citrix Environment

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? Sur

RE: [DUG]: Interbase and Citrix Environment

From: 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

RE: [DUG]: Interbase and Citrix Environment

ipients of list 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 Inte

[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 on a Citrix Server. Have the executable on this server.

Re: [DUG]: Interbase Desktop

pients of list delphi" <[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

Re: [DUG]: Interbase Desktop

tiple recipients of list delphi" <[EMAIL 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 &g

RE: [DUG]: Interbase Desktop

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

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 - Delphi List - [EMAIL PROTECTED]

RE: [DUG]: Interbase Desktop

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

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 you do changes to triggers and procedures it shouldnt and can corupt the DB but it includes

RE: [DUG]: Interbase Desktop

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]: 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 --- New Zealand Delphi Users

Re: [DUG]: Interbase X SQL Server

Dennis > Also, if you use dbgrids and client side cursors, it keeps record locks on > SQL server until the user scrolls to the end of the recordset. This can > then cause problems on other machines needing to write to the locked > records. I have found that you should either keep the recordsets

RE: [DUG]: Interbase X SQL Server

ent: Thursday, 13 September 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

RE: [DUG]: Interbase X SQL Server

y, 13 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 maintainin

RE: [DUG]: Interbase X SQL Server

fault 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 delph

Re: [DUG]: Interbase X SQL Server

ssage - 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] ! >A

[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 and raising a big system developed in Delphi 4 Client/Server. This system was made by another person t

[DUG]: Interbase, Stored Procs, Computed Fields, UDFs and Performance

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 or

RE: [DUG]: Interbase

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

[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

[DUG]: Interbase equivalent to Oracle Sql*loader??

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 net.

RE: [DUG]: Interbase/Delphi Stored Procedure

of list delphi Subject: RE: [DUG]: Interbase/Delphi Stored Procedure I had thought the ID_SLPRTY was the Parameter, but can see also that it is a return value so will try getting at it via fields[0].asIniteger. Thanks all for your help/suggestions. -Original Message- From: Sandeep

RE: [DUG]: Interbase/Delphi Stored Procedure

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 generato

Re: Re: [DUG]: Interbase/Delphi Stored Procedure

"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 > >selec

Re: [DUG]: Interbase/Delphi Stored Procedure

> > 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 para

RE: [DUG]: Interbase/Delphi Stored Procedure

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 proced

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 has not incremented. > > I have an IB Insert TRigger that correctly u

[DUG]: Interbase/Delphi Stored Procedure

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

[DUG]: Interbase Backdoor

Hi all, For everyone using Interbase, you should read this immediately, and act now if required. The problem was highlighted by the Open Source Firebird project, and a fix is available - a link is at the referenced website. http://www.cert.org/advisories/CA-2001-01.html --

Re: [DUG]: Interbase ASP.

ROTECTED]> 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

Re: [DUG]: Interbase ASP.

- From: "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 interbas

[DUG]: Interbase ASP.

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] We

[DUG]: Interbase ASP.

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] We

Re: [DUG]: Interbase

> 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.

RE: [DUG]: Interbase

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 i

Re: [DUG]: Interbase

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 1

RE: [DUG]: Interbase

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

  1   2   3   4   >