I.T. Discussion Community!
-Collapse +Expand
DBA
Search DBA Group:

Advanced
-Collapse +Expand DBA Store
PRESTWOODSTORE

Prestwood eMagazine

March Edition
Subscribe now! It's Free!
Enter your email:

   ► MB LobbyDBA, Databases, & Data Board   Print This     

Interbase Topic

Borland Interbase
 Show:
New Activity New Threads Oldest Unanswered Most Active Most Read
  


25 Threads:

Add New ThreadRandom Thread

Thread 25 of 25
Thread Starter  

essystem
Is InterBase The Best Choice ?
I develop system for stores still in CLipper 5.3 I will change to Delphi. Is the InterBase the best choice for use in customers that will not pay for traditional products as SQLServer and others ? Is IB faster enough to run in PIII 800Mhz 128 MB RAM as server for 2 to 10 machines in a LAN ? And does it keep fast even when grow about to 200,000 to 300,000 register in two or three tables ? My system handle 20 to 2000 register in terms of sells and 50 to 5000 registers in terms of selled products a day. If IB is not the best choice what should i use ?, Thank You !
18 years ago
2 replies. Last post:

Shane.J2
Advanced filters for check outcomes. Game Guardian APK Download App – latest Version of 2017 [No Root] If you want to learn how to make your own trainers and scripts for Android games.
14 months ago
Nothing New Since Your Last Visit
2581
Hits

Thread 24 of 25
Thread Starter  

JCarlos
Problem trying to insert 10,000 records under Red
{Too Long!}
15 years ago
Nothing New Since Your Last Visit
4297
Hits

Thread 23 of 25
Thread Starter  

Ritche M
Unknown Function: substring?
i don't know why SUBSTRING is an unknown function when i make a select statement in SQL Explorer., , ex: select SUBSTRING("borland" from 4 to 4) from TABLE1, , error is either: unknown function or, invalid token "from", , Please help...
16 years ago
Nothing New Since Your Last Visit
9171
Hits

Thread 22 of 25
Thread Starter  

Mike Prestwood
Download InterBase 6.01 and Related Tools
{Too Long!}
19 years ago
1 Reply:

Anonymous
--- KOUAME
56 months ago
Nothing New Since Your Last Visit
14004
Hits

Thread 21 of 25
Thread Starter  

Alex Diogo Moreira
Interbase in Internal Net
Being a computer the server with the archive gdb as to make for has access it other stations? Confused
15 years ago
Nothing New Since Your Last Visit
3188
Hits

Thread 20 of 25
Thread Starter  

Ritche M
substring in stored proc?
how do we use substring is stored proc using variables. substring will only work with table columns., ex. variable1 = 'borland', how do we get 'land' from borland?, , need help... thanks.
16 years ago
1 Reply:

Scott
{Too Long!}
16 years ago
Nothing New Since Your Last Visit
3538
Hits

Thread 19 of 25
Thread Starter  

assure
Interbase 6.0 with Paradox 9.0
Hello for all! , , I am not getting to have success using Paradox 9.0 developers edition with Interbase 6.0. I am not getting to type the characters τ and π, and nor to record in the table. It would be possible an example of as best uses Interbase with Paradox. , , Thank you very much. Big Grin!
17 years ago
1 Reply:

Scott
The question has been forwarded to this link:, , [URL=http://205.158.230.147/cgi-bin/ubb/ultimatebb.cgi?ubb=get_topic&f=16&t=000544#000003]Object PAL with InterBase[/URL]
17 years ago
Nothing New Since Your Last Visit
2819
Hits

Thread 18 of 25
Thread Starter  

assure
FIELD NUMERIC WITH PARADOX
I recently tried to create a new table using Corel Paradox 9. I chose INTERBASE for the table type. I don't get to type in the form the field type NUMERIC. How to do ?, , Thanks [Help]
17 years ago
2 replies. Last post:

assure
Hello for all! , , I am not getting to have success using Paradox 9.0 developers edition with Interbase 6.0. I am not getting to type the characters τ and π, and nor to record in the table. It would be possible an example of as best uses Interbase with Paradox. , , Thank you very much.
17 years ago
Nothing New Since Your Last Visit
4403
Hits

Thread 17 of 25
Thread Starter  

os2
how to manadage that...
i use interbase 6 and delphi, , i try to do a location car program, , i have a table named Location with field, nolocation, km...., , i have another table named vehicule with fied, novehicule, km..., , and i have another table location_vehicule who join Location and vehicule with field, , nolocation and novehicule, , i want to know how to manage a new location..., , when i go to this form should I ask a new nolocation to interbase (generator) and after add car to this location or, , Inser car to the location, and before post the location ask a nolocation to interbase insert this number in nolocation field of location table and after in nolocation field of location_vehicule, , or any other tips to do that?, , database diagram, , [IMG]http://pages.infinit.net/borland/diagramme2.gif[/IMG], , form picture, [IMG]http://pages.infinit.net/borland/testing.png[/IMG]
17 years ago
5 replies. Last post:

Scott
{Too Long!}
17 years ago
Nothing New Since Your Last Visit
2819
Hits

Thread 16 of 25
Thread Starter  

Brex
interbase Vs Access
I need convert a database access, in a database interbase bvut I can't make it ? what is the solution exist one free program in internet?
17 years ago
1 Reply:

Scott
{Too Long!}
17 years ago
Nothing New Since Your Last Visit
4073
Hits

Thread 15 of 25
Thread Starter  

Giancarlo
Keyword & fields name in Interbase
I'm translating a Microsoft SQLServer database on an Intrebase database. I have some difficulties on fields such as: password, auto, position. These fields name are not allowed in Interbase because you can't use a keyword for name of a fields., How can I do?, , Tankyou for your answers,, Giancarlo
18 years ago
1 Reply:

Scott
{Too Long!}
17 years ago
Nothing New Since Your Last Visit
2538
Hits

Thread 14 of 25
Thread Starter  

rreiss
Incompatibility with DATE type in Paradox and Crea
I recently tried to create a new table using Corel Paradox 10. I chose INTERBASE (using the free Interbase 6 download)for the table type. One table was easily created, but a second table, where I chose DATE for the date field created an error, telling me that Interbase was using TIMESTAMP. Unfortunately, TIMESTAMP is not a choice on the field type dropdown dialogue. Going the otherway and using Interbase SQL, I could create a table with a DATE datetype, but Paradox wouldn't let me add it to the datamodel on a form. Any ideas how to get around this problem?, Would I still have the problem with the Corel Linux version and Interbase for FreeBSD/Linux? (I have Corel Office for Linux on order).
17 years ago
1 Reply:

Scott
{Too Long!}
17 years ago
Nothing New Since Your Last Visit
2909
Hits

Thread 13 of 25
Thread Starter  

absolut
ib use...
hi everyone., i would like to know if IB is not even a option to be considered for desktop-database apps?, and what about the possibe opts, does bde compensates even with its 15MB of instalation??, and what about access?? i never really considered it, would you recomend it??, , i know that the 2 ending questions should be in another forum, but they come in sequence of my first question., , TIA, bruno
17 years ago
3 replies. Last post:

Scott
{Too Long!}
17 years ago
Nothing New Since Your Last Visit
3094
Hits

Thread 12 of 25
Thread Starter  

absolut
ib password
Hi again!!, , this time i have a question concerning IB and the users password., i run into smtgh that left me thinking, i dnt know if im missing smthg concerning to DB security, but here is the situation:, i installed IB and created a db, ive populated the db to my needs, and obviously change the sysdba default password to another password, then i uninstalled IB, so i could upgrade to another version i downloaded, then when i gone to use my DB i wasnt wiht the password i left it, it was with the default masterkey password, obviously i could see all the information it was within. this left a bit apreensive, as there was no real security in this . i dnt know if im missing smtgh here, even if im missing smthg very basic, but i would like to know if there is anyway to really protect mt DB with a password and prevent some one to open my DB without the pass i have set., , TIA, bruno
17 years ago
1 Reply:

Scott
{Too Long!}
17 years ago
Nothing New Since Your Last Visit
2160
Hits

Thread 11 of 25
Thread Starter  

nzayas
problems with interbase-gbak-restore
I have a problema with a GDB., I execute a query into this gdb and the perfomance of this query is good, bat I make a, backup and restore to my gdb and I try to execute the same query and now the time to execute this query is very long., The plan that ibserver uses to execute the query in both database is different. Why?, Is there any problem with gbak restore GDB's?
17 years ago
2 replies. Last post:

nzayas
Firstly, thank you for you repply., The setting deactive indexes was off when I made the restore and de size page was the same than the original GDB. I tried with a bigger size page but the result was worst.
17 years ago
Nothing New Since Your Last Visit
3330
Hits

Thread 10 of 25
Thread Starter  

Phoenix
"reached end of file error"
This error message appears on multiple database in Interbase when trying to open the database. Please help!
17 years ago
1 Reply:

Scott
{Too Long!}
17 years ago
Nothing New Since Your Last Visit
2357
Hits

Thread 9 of 25
Thread Starter  

Sascha
Interbase Database
Hy, Can somebody tell me how I can change the company name and the database name in a Interbase Database with an SQL statement., I would be very glad if there is a way.
17 years ago
Nothing New Since Your Last Visit
2941
Hits

Thread 8 of 25
Thread Starter  

Zibi
Paging and ASP
I look how to make paging in ASP and interbase, I can use ADO. What is another possibilty?
17 years ago
Nothing New Since Your Last Visit
2154
Hits

Thread 7 of 25
Thread Starter  

Alan
Arrays in Interbase
Is there an open array type in Interbase where you don't have to declare a length in advance? eg int[], , Also is there a source of examples of how to use arrays in Interbase?
17 years ago
Nothing New Since Your Last Visit
2486
Hits

Thread 6 of 25
Thread Starter  

Alan
Interbase
I am using an older version of Interbase (ie 5.1 I think). I would like to use it to manipulate both dates and times. I had a lot of trouble understanding the online manual., , Are there any examples of how to do this in a stored procedure? Also is there a TIME datatype in Interbase?, , Thanks for your help., , Alan
17 years ago
1 Reply:

Scott
{Too Long!}
17 years ago
Nothing New Since Your Last Visit
2124
Hits

Thread 5 of 25
Thread Starter  

Tracey
IB6, win2000 pro, Apache2
Has anyone here had any success using these 3 software in combination? i am trying to set up a win2000 pro machine as my web server. I have installed IB6 on two 2000 machines so far and receive a "unavailable database" error message on both when trying to access my application., , My current web server has NT4, apache 1.3 and IB5.5 with no problems. My new web-server-to-be is running Apache2, IB6.
17 years ago
Nothing New Since Your Last Visit
2454
Hits

Thread 4 of 25
Thread Starter  

Sancraian Marius
Update clients data
I have two clients conected to the same database. When a client update a record in a table, I don't know how to update the records for the other client (the client must refresh the data to update the records). How can I do this automatically?, Thanks in advance.
17 years ago
1 Reply:

Simon Wood
The only way that client 2 can see the changes client 1 has made is for client 2 to issue another select. You cannot force InterBase to refresh a client !
17 years ago
Nothing New Since Your Last Visit
3053
Hits

Thread 3 of 25
Thread Starter  

Royke74
Check in trigger
Hi there,, , Can anyone tell me how to check for a string length in a trigger (BEFORE INSERT). Something like this. It should be simple but i cannot find anything about this in (online)help., , CREATE TRIGGER check_user_length FOR INLOGGEN, BEFORE INSERT AS, BEGIN, IF LENGTH(name) > 15) THEN EXCEPTION wrong_user_length;, END, , Thanks!
17 years ago
2 replies. Last post:

Royke74
Thanks Simon i'll try it!
17 years ago
Nothing New Since Your Last Visit
3112
Hits

Thread 2 of 25
Thread Starter  

PANTLORD
Cannot insert into triggered interbase field.
Hi there,, , I'm having trouble inserting a value into one of my interbase tables. The table in question has 5 fields, the primary key Operator_ID has a trigger set on it to autoincrement. It is a NOT NULL field as it is the primary key, so I don't enter a value via my Delphi front end. I have also set the required property for this field in Delphi to false., , I consistently am getting the message 'Field XXX requires a value however'., , Should interbase not handle this itself the trigger type is BEFORE INSERT. Within delphi I am using a DataModule with a an IBdatabase/IBTransaction/IBTable and a standard datasource as components and am attempting o do the insert via a navigation component and dbgrid. , , Any suggestions this thing is driving me crazy slowly but surely., , Thanks in advance, PL
17 years ago
1 Reply:

Simon Wood
I use this technique all over the place in my apps and don't see the problem that you have. I am using ObjectPAL and pass-through SQL., , Have you tried inserting a record using an INSERT statement in Windows iSQL ? If this fails then you have an InterBase problem otherwise it is something in your Delphi App, , Have you tried doing a simple hard-coded insert using a TQuery component under a button in your Delphi App ?
17 years ago
Nothing New Since Your Last Visit
3243
Hits

Thread 1 of 25
Thread Starter  

Simon Wood
InterBase Keepalives
{Too Long!}
17 years ago
Nothing New Since Your Last Visit
2036
Hits

New Thread
-
   Contact Us!
 
PrestwoodBoards.com was developed and is maintainted by me. Do you have a question or suggestion? Do you see a problem? Contact me now. My goal is to build an ad-free and spam-free source of I.T. information with many contributers (ok to promote your website/company in your bio). Yes, my company Prestwood IT Solutions is mentioned in my bio which shows with every post, but you can contribute and promote your pet project too!

2,194 People Online Now!!  
Sign In to see who's online now!  Not a member? Join now. It's free!
Show more stats...


©1995-2019 PrestwoodBoards  [Security & Privacy]
Professional IT Services: Coding | Websites | Computer Tech