The Origin Forum
File Exchange
Try Origin for Free
The Origin Forum
Home | Profile | Register | Active Topics | Members | Search | FAQ | Send File to Tech support
 All Forums
 Origin Forum
 Origin Forum
 Database connectivity

Note: You must be registered in order to post a reply.
To register, click here. Registration is FREE!

Screensize:
UserName:
Password:
Anti-Spam Code:
Format Mode:
Format: BoldItalicizedUnderlineStrikethrough Align LeftCenteredAlign Right Horizontal Rule Insert HyperlinkUpload FileInsert Image Insert CodeInsert QuoteInsert List
   
Message:

* HTML is OFF
* Forum Code is ON
Smilies
Smile [:)] Big Smile [:D] Cool [8D] Blush [:I]
Tongue [:P] Evil [):] Wink [;)] Clown [:o)]
Black Eye [B)] Eight Ball [8] Frown [:(] Shy [8)]
Shocked [:0] Angry [:(!] Dead [xx(] Sleepy [|)]
Kisses [:X] Approve [^] Disapprove [V] Question [?]

 
Check here to subscribe to this topic.
   

T O P I C    R E V I E W
couturier Posted - 01/09/2017 : 03:30:38 AM
Origin Ver. and Service Release (Select Help-->About Origin): 2017
Operating System: win7 64bit

Hi,
happy new year to everybody.

I'm trying to start using the database capabilities of Origin but I'm facing a few issues. Any help is much appreciated.

Major issue
It is not possible to write in a table in there's a foreign key between this table and another one.

Minor issues
1. OC function writeRecordSet/ReadRecordSet: is there a way to write variables/read into variables ?

2. writing in a table is very long. It looks to be beacause of odbc driver. Is there any possibility of native access to db such as MySQL ?
2   L A T E S T    R E P L I E S    (Newest First)
couturier Posted - 01/11/2017 : 04:07:43 AM
Thanks for your answer CP.
I'll post detailed exemple and steps to reproduce asap
cpyang Posted - 01/10/2017 : 12:45:10 AM
We can add MySQL example, but can you describe a bit more about the tables? Like if you can give a simple example.

CP

The Origin Forum © 2020 Originlab Corporation Go To Top Of Page
Snitz Forums 2000