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:
640 x 480
800 x 600
1024 x 768
1280 x 1024
UserName:
Password:
Anti-Spam Code:
Format Mode:
Basic
Help
Prompt
Format:
Font
Andale Mono
Arial
Arial Black
Book Antiqua
Century Gothic
Comic Sans MS
Courier New
Georgia
Impact
Lucida Console
Script MT Bold
Stencil
Tahoma
Times New Roman
Trebuchet MS
Verdana
Size
1
2
3
4
5
6
Color
Black
Red
Yellow
Pink
Green
Orange
Purple
Blue
Beige
Brown
Teal
Navy
Maroon
LimeGreen
Message:
* HTML is OFF
*
Forum Code
is ON
Smilies
[quote][i]Originally posted by couturier[/i] [br]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 ? [/quote]
Check here to include your profile signature.
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
Snitz Forums 2000