marcwolf
Posts: 361
|
Posted: 05/19/2008, 11:24 PM |
|
Hi Folks.
I am trying to add in some intelligence into my databases by using stored procedures.
I am using CCS 3 (latest) ,MySQl 5.0 (latest). , MyODBC 3 (latest)
I am having several issues.
1. If I try and use a Stored Procedure (SP) in the Grid Builder I cannot see any of its fields or parameters so I cannot use it of building
2. If I Create a Form using the Form Builder I cannot see any of the SP at all
3. If I use a record to generate the form - I can use the Custom Insert/Update etc however likewise the assignment between form field and stored procedure requires a lot of hand coding.
Had anyone had any luck with using SP from MySQL
Many thanls fr any input
Dave
_________________
' Coding Coding Coding
Keep Those Keyboards Coding.
Raw Code!!!!!!!
|
|
|
marcwolf
Posts: 361
|
Posted: 06/02/2008, 4:10 PM |
|
Hi Folks.
I've removed this as no one answered it.
I am making some progress but its definately slow.
_________________
' Coding Coding Coding
Keep Those Keyboards Coding.
Raw Code!!!!!!!
|
|
|
marcwolf
Posts: 361
|
Posted: 06/02/2008, 4:10 PM |
|
Hi Folks.
I've removed this as no one answered it.
I am making some progress but its definately slow.
_________________
' Coding Coding Coding
Keep Those Keyboards Coding.
Raw Code!!!!!!!
|
|
|
marcwolf
Posts: 361
|
Posted: 06/02/2008, 4:10 PM |
|
Hi Folks.
I've removed this as no one answered it.
I am making some progress but its definately slow.
_________________
' Coding Coding Coding
Keep Those Keyboards Coding.
Raw Code!!!!!!!
|
|
|
wkempees
Posts: 1679
|
Posted: 06/02/2008, 4:38 PM |
|
MB: have you asked support http://support.yessoftware.com.
I would have loved to help but target platform to different, sorry.
Walter
(always dissapointed if someone is dissapointed)
_________________
Origin: NL, T:GMT+1 (Forumtime +9)
CCS3/4.01.006 PhP, MySQL .Net/InMotion(Vista/XP, XAMPP)
if you liked this info PAYPAL me: http://donate.consultair.eu
|
|
|
dang
Posts: 11
|
Posted: 02/06/2009, 10:58 AM |
|
Quote marcwolf:
Hi Folks.
I am trying to add in some intelligence into my databases by using stored procedures.
I am using CCS 3 (latest) ,MySQl 5.0 (latest). , MyODBC 3 (latest)
I am having several issues.
1. If I try and use a Stored Procedure (SP) in the Grid Builder I cannot see any of its fields or parameters so I cannot use it of building
2. If I Create a Form using the Form Builder I cannot see any of the SP at all
3. If I use a record to generate the form - I can use the Custom Insert/Update etc however likewise the assignment between form field and stored procedure requires a lot of hand coding.
Had anyone had any luck with using SP from MySQL
Many thanls fr any input
Dave
Hi Dave
I've got similar issue with Stored Procedure. Here what I found, tested and work well:
If you already have a Form connected to a table:
DBConnection.Execute("CALL procedureName")
If you don't have any Form and it's just a call to a mySql procedure, you must create a new connection like:
dim conn
set conn = new clsDBconnectionDatabaseName
conn.open
conn.execute("CALL procedureName")
conn.Close
Set conn = Nothing
Hope it's help someone
_________________
Dan |
|
|
|
|
|
|
|