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 (20 months ago)
Visits: 17
Member pending approval.
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
87 days ago

Steven.G
> The real surprise has been just how much has worked without major re-factoring < that is VERY cool
43 days ago
Nothing New Since Your Last Visit
200
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!}
43 days 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!}
85 days ago
Nothing New Since Your Last Visit
6001
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
85 days ago
Nothing New Since Your Last Visit
Corel Paradox / ObjectPAL Coding
More...
-
   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,884 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