I.T. Discussion Community!
John Ocean -Collapse +Expand
-Collapse +Expand
John.O2
-Collapse +Expand Profile◄╣
Member Info
Member Narration

POSTS:
MB Posts (13)

Search John.O2:

Advanced
Business Account . . .
PS_291
-- --




Represented here by . . . 
Real Name:  John Ocean
Primary Role:  ---
Joined: Aug 2017 (25 months ago)
Visits: 17
Old Account!
If this is your account, sign in to activate web presence data (sign in quarterly to keep active). Alternatively, you can subscribe to our monthly eMag with a valid email address.
Web Presence Hidden.
Once above is taken care of, full Profile content will display including back links, about me, my message, custom Profile html, social networking links, message board signature, company profile, etc.

Message Boards Activity

13 posts.
More...

Thread 6 of 6
Thread Starter or a Reply (but not last)  Group

PS_291
PDOX11 over MSSQL (ODBC) - Schema in Table Names
Might anyone here know a way to configure ODBC/SQLEXPRESS under the BDE to return table names without a schema prefix (i.e., tablename rather than dbo.tablename)? Should I be looking at a different SQL DB?  Ideally, I’d like to point the alias that currently references the main paradox database to one referencing tables ported to sql and look at what needs fixing from there.  Thanks to a tool created and shared on codeproject by one of the forum members (thanks Igor!), database conversion to SQLEXPRESS went surprisingly easily, with only a few minor field type changes needed across hundreds of tables. I’m connecting to the SQL db fine from paradox via odbc. That said, I’ll consider a different back end (Firebird? PostgreSQL?) if it means the Paradox app will require fewer changes; I’m dealing with many forms and lots of code and porting the back end is a step toward a full conversion away from Paradox. Thanks! John
8 months ago

Steven.G
> The real surprise has been just how much has worked without major re-factoring < that is VERY cool
6 months ago
Nothing New Since Your Last Visit
358
Hits

Corel Paradox / ObjectPAL Coding

Thread 5 of 6
Thread Starter or a Reply (but not last)  Group

PS_291
RE: PDOX11 over MSSQL (ODBC) - Sch
{Too Long!}
6 months ago
Nothing New Since Your Last Visit
Corel Paradox / ObjectPAL Coding

Thread 3 of 6
Thread Starter or a Reply (but not last)  Group

lja
using alias to oracle, datamodel gives error
{Too Long!}
Posted to MB Topic: Paradox Forms « Paradox Board
11 years ago

John.O2
{Too Long!}
8 months ago
Nothing New Since Your Last Visit
6107
Hits

Corel Paradox / ObjectPAL Coding

Thread 2 of 6
Thread Starter or a Reply (but not last)  Group

PS_291
RE: using alias to oracle, datamod
... a brief update for anyone else encountering this issue: with ODBC against MySQL, I was able to address the error by creating the primary keys on the MySQL tables used in the data model of the form using the following DDL: ALTER TABLE `tablename` ADD CONSTRAINT `tablename` PRIMARY KEY (`Primary_Key_Field_Name`) ... where tablename is the name of the paradox table that was migrated to the new back end with the name preserved. YMMV (particularly against other back-end DB’s). Best, John
Posted to MB Topic: Paradox Forms « Paradox Board
8 months ago
Nothing New Since Your Last Visit
Corel Paradox / ObjectPAL Coding
More...

Follow PrestwoodBoards on: 


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