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

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

{Too Long!}

Posted to MB Topic: Interbase

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

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

{Too Long!}

Posted to MB Topic: Interbase

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 ,

Posted to MB Topic: MS SQL

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

{Too Long!}

Posted to MB Topic: DB Other & Misc.