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

Advanced
-Collapse +Expand DBA Store
PRESTWOODSTORE

Prestwood eMagazine

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

   ► MB LobbyDBA, Databases, & Data Board   Print This    All Groups  

DBA, Databases, & Data New Activity

Switch to:  New Posts (ALL TYPES)
  


25 Threads:


Thread 25 of 25
Thread Starter  

Marine1
Homework help
Hello,, , Need some homework help on databases such as, creating an ERD, data sets and so on. This stuff is bit over my head just need to survive at this point. I just don't the brain at this time for Oracle SQL. Thanks., , Until that time...
Posted to MB Topic: Oracle
15 years ago
Nothing New Since Your Last Visit
4409
Hits

Thread 24 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 !
Posted to MB Topic: Interbase
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.
17 months ago
Nothing New Since Your Last Visit
2692
Hits

Thread 23 of 25
Thread Starter  

JCarlos
Problem trying to insert 10,000 records under Red
{Too Long!}
Posted to MB Topic: Interbase
15 years ago
Nothing New Since Your Last Visit
4385
Hits

Thread 22 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...
Posted to MB Topic: Interbase
16 years ago
Nothing New Since Your Last Visit
9267
Hits

Thread 21 of 25
Thread Starter  

vinit.s

Posted to MB Topic: DB Other & Misc.
37 months ago
Nothing New Since Your Last Visit
1152
Hits

Thread 20 of 25
Thread Starter  

snow_boy
Delphi 6 and Toraclequery.
hi.. I am still a beginner in the delphi programming. so I am just wondering if anyone can help me with a problem that I have. I am current using DOA(Direct Oracle Access), by using that I want to get a procedure that are in the oracle server and use it in my program. I have use the TOraclePackage and in it there is a component "callprocedure" and "callFunction" well I know how to use them and all.. but I am having great trouble of declaring them. , I also have use the TOracleQuery, but it is the declara in the SQL editor that annoying me. coz it gave me error message and etc. so if u can help me with the SQL declare and that will be great., , , thx in advance, Billy
Posted to MB Topic: Oracle
17 years ago
1 Reply:

Anonymous
wow 13 years and nobody help you, I have the same problem, I´m fresh on delphi programming.  Regards! --- Dulce
49 months ago
Nothing New Since Your Last Visit
5202
Hits

Thread 19 of 25
Thread Starter  

Mike Prestwood
Download InterBase 6.01 and Related Tools
{Too Long!}
Posted to MB Topic: Interbase
19 years ago
1 Reply:

Anonymous
--- KOUAME
59 months ago
Nothing New Since Your Last Visit
14223
Hits

Thread 18 of 25
Thread Starter  

Johnc
paradox 9 tables to mysql
Does anyone know how to convert paradox 9 tables into mysql? If so is the conversion simple and does paradox have a built in function or script that can be run to do this? Which tables are more stable for alot of users and records being accessed per day Paradox or SQL , Big Grin!
Posted to MB Topic: MS SQL
18 years ago
3 replies. Last post:

eric_felleiter
Thanks kwmillican I can use it.
9 years ago
Nothing New Since Your Last Visit
5564
Hits

Thread 17 of 25
Thread Starter  

simd01
Cannot see fields in MS SQL tables in Paradox
I am attempting to convert a Paradox database into MS SQL back end using Paradox 10 as a front end. I can now connect to MS SQL 2008 Server Express and see tables in the Paradox data model but when I double click them I just get the SQL hourglass and that is it - none of the fields appear for selection (my dummy tables contain char(10) fields).  Has anyone else seen this?
Posted to MB Topic: MS SQL
9 years ago
1 Reply:

Anonymous
I replied to your other post so I am curious. How are you connecting to the SQL server? Did you use the BDE native driver? Does that work? Did you use ODBC? --- Robert M.
9 years ago
Nothing New Since Your Last Visit
3730
Hits

Thread 16 of 25
Thread Starter  

mebfbi
92 Compliant // Update Statement
{Too Long!}
Posted to MB Topic: DB Other & Misc.
10 years ago
Nothing New Since Your Last Visit
4658
Hits

Thread 15 of 25
Thread Starter  

STRUCTURED2000
Oracle Management server (OMS)
Please, help. I'm new to Oracle 9i. I pracyice on my XP homet home trying to log in to enterprise OMS. I installed Oracle 9i, login to Enterprise OMS. When I logged off and turned off and on the computer, my login effort is unsuccesful and if I reinstalled my XP OS again and reintall oracle 9i, I will be able to login to enterprise OMS but once I turned off and restart my computer, I'm out. Do you have a clue what's going on., Thank you.
Posted to MB Topic: Oracle
16 years ago
1 Reply:

adamlum
Have you made sure the Oracle service is starting when you reboot and log into Windows? It should be set to automatic so that it will start up on it's own.
12 years ago
Nothing New Since Your Last Visit
4116
Hits

Thread 14 of 25
Thread Starter  

brian p kim
Abnormal error - MS SQL board
= = = = =, Sorry, UBB has encountered an unexpected, fatal error. This error is extremely abnormal. Please contact the board administration. The error text is:, , Can't open 'NonCGIPath/cache-(cache_pw)/ubb_files/forums/Forum39/000018.cgi'. , , I was unable to find that file or directory. Please check the paths., , The exact error returned by the operating system is:, No such file or directory, , ╗ Please use your browser's back button to return., = = = = =
Posted to MB Topic: MS SQL
16 years ago
1 Reply:

adamlum
Thanks for the notice. Another error produced by the old boards system, which is why we created our own at Prestwood.  Hopefully no more errors or headaches.
12 years ago
Nothing New Since Your Last Visit
15843
Hits

Thread 13 of 25
Thread Starter  

Wes Peterson
ElevateDB - A Compelling Choice
{Too Long!}
Posted to MB Topic: DB Other & Misc.
12 years ago
2 replies. Last post:

adamlum
Wes has always had nothing but praise for DBISAM but it has only been available for Borland products such as Delphi and C++ Builder, IDE's I don't use, so I haven't had the opportunity to try it out first hand.  I am definitely looking forward to trying out ElevateDB with Visual Studio 2005.
12 years ago
Nothing New Since Your Last Visit
9038
Hits

Thread 12 of 25
Thread Starter  

KCRABBE
SQL and blob and long binary data
We run a client database using MS SQL., , We can get access to some of the data via ACCESS but there are fields that are "blob" and "long binary data" that we cannot get direct access to via ACCESS., , The vendors will not help us claiming proprietary software issues., , Is there any "simple" way or any third-party products that will give us access to the contents of the blob and logn binary data files?, , We are not extremely MS SQL literate but we'd be willing to try any suggestions., , Thanks, KC
Posted to MB Topic: MS SQL
15 years ago
1 Reply:

mprestwood
Hi Kathy,, , I think you might be out of luck. If the vendor has put proprietary data in a binary field, then you'll have to rely on them to help you get the data out. By all means, you can use Access, or Paradox, or Delphi (for example) to read the data into a binary variable and then write it to disk and look at it to see if you can make sense of it., , Mike
15 years ago
Nothing New Since Your Last Visit
3115
Hits

Thread 11 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
Posted to MB Topic: Interbase
15 years ago
Nothing New Since Your Last Visit
3249
Hits

Thread 10 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.
Posted to MB Topic: Interbase
16 years ago
1 Reply:

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

Thread 9 of 25
Thread Starter  

rrs
Linking to Oracle
I have problems when I try to link to Oracle table. I get an error message "Invalid field definition 'Field Name ' in defnition of index or relationship"., The table I am trying to link to is really big. It has around 260 columns Could that cause a problem ? , Thanks for your help.
Posted to MB Topic: Oracle
16 years ago
1 Reply:

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

Thread 8 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!
Posted to MB Topic: Interbase
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
2876
Hits

Thread 7 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]
Posted to MB Topic: Interbase
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
4446
Hits

Thread 6 of 25
Thread Starter  

yeudba
progress troubles
dear all, , i am trying to retrieve data from a progress 9 database via odbc (datadirect 4.0) but get the following message: driver's SQLSetConnectAttr failed, feature not implemented..., can anybody help me with this one?, , greetz, carl
Posted to MB Topic: DB Other & Misc.
17 years ago
1 Reply:

SANDMAN
{Too Long!}
17 years ago
Nothing New Since Your Last Visit
2509
Hits

Thread 5 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]
Posted to MB Topic: Interbase
17 years ago
5 replies. Last post:

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

Thread 4 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?
Posted to MB Topic: Interbase
17 years ago
1 Reply:

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

Thread 3 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
Posted to MB Topic: Interbase
18 years ago
1 Reply:

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

Thread 2 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).
Posted to MB Topic: Interbase
17 years ago
1 Reply:

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

Thread 1 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
Posted to MB Topic: Interbase
17 years ago
3 replies. Last post:

Scott
{Too Long!}
17 years ago
Nothing New Since Your Last Visit
3140
Hits
Follow PrestwoodBoards on: 


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