Re: Can foreign keys reference tables in another database?

2005-12-16 Thread Eric Grau
Eric Grau wrote: JamesDR wrote: Scott Plumlee wrote: sol beach wrote: Why in the world are you trying to keep multiple copies of the data? Why can't you just access the 'master database'? On 12/16/05, Scott Plumlee <[EMAIL PROTECTED]> wrote: I am trying to mainta

Re: Can foreign keys reference tables in another database?

2005-12-16 Thread Eric Grau
JamesDR wrote: Scott Plumlee wrote: sol beach wrote: Why in the world are you trying to keep multiple copies of the data? Why can't you just access the 'master database'? On 12/16/05, Scott Plumlee <[EMAIL PROTECTED]> wrote: I am trying to maintain one master list of countries and the st

Re: Direct access to a mySQL DB via Visual Basic

2001-07-25 Thread Eric Grau
MyVbQL is a direct interface to MySQL databases ... you don't need to use the ADO/ODBC combination ... you can get some more details on the MyVbQL web page ... http://www.icarz.com/mysql/index.html Eric Stephen Sherlock wrote: > I've been told that it's possible to connect directly to a mySQ

Re: MyVbQL

2001-07-11 Thread Eric Grau
Check out http://www.icarz.com/mysql/index.html ... Eric Cal Evans wrote: > What is MyVbQL? > Cal > * > * Cal Evans > * Senior Internet Dreamer > * http://www.calevans.com > * > - Original Message - > From: "Prabu Subroto" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Wednesday,

Re: MySQL on VB

2001-06-15 Thread Eric Grau
Or MyVbQL ... http://www.icarz.com/mysql/ Eric Rolf Hopkins wrote: > Can connect using MyODBC. > > - Original Message - > From: "Andrew" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Friday, June 15, 2001 13:52 > Subject: RE: MySQL on VB > > > > > I need some help. > > > > I wo

Re: MySQL++ for Visual Basic

2001-05-31 Thread Eric Grau
Robert Vetter wrote: > D'Arcy Rittich wrote: > > > > > Actually you dont't need a ocx. You can call the MySQL API functions, > > > which are in a dll file. > > > > > > Robert > > > > Do you have any examples of that with VB? > > No, I don't. But you can take a look at an example written in C. > >

Re: API or ADO??

2001-05-05 Thread Eric Grau
The application we develop here at icarz was written using MyODBC and ADO ... I wrote the MyVbQL API to replace the use of ADO in our application with minimal code changes ... The names and functionality of most of the methods and properties are modeled after ADO methods and properties ... Anyone

Re: API or ADO??

2001-05-05 Thread Eric Grau
What API are you referring to ...MyVbQL.dll ? If not you should check it out ... http://www.icarz.com/mysql/index.html In my opinion, MyVbQL is the API that you should use ... but my opinion is a little biased since I am the one that wrote it ... Eric Warren van der Merwe wrote: > Hi again >

Re: ROWNUM???

2001-03-19 Thread Eric Grau
I have no problem doing this with server variables ... here is an example that I tried on the acc (account) table in our db ... SET @a:=0; SELECT @a:=@a+1 AS MyRowNum, acc.* FROM acc; This gives me the result that you are looking for ... Eric Peter Holm wrote: > Hi, > how do I get something

MyVbQL.dll version 2.0.0 released

2001-02-12 Thread Eric Grau
e adding a FAQ page soon. Enjoy !!! Eric Grau icarz, inc. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-ma

Re: Connecting to MySQL with Visual Basic

2001-01-19 Thread Eric Grau
You can also use MyVbQL.dll ... take a look at http://www.icarz.com/mysql/index.html Eric Rolf Hopkins wrote: > Someone sent me some samples of various connection type (ADO, DAO, etc) > about a month ago but I'll post off list. > > - Original Message - > From: "Dwight Mowbray" <[EMAIL