main logo
Subject: RE: AW: Building a vlb from an sql-dump or from csv-data
Author: Olaf Schmidtmann
Posted: 2000/11/30 08:33:50
 
View Entire Thread
New Search


Thanks Scott!

I already got a lingo-written converter which converts a v12-db to a
v-db from a nice newgroup-member called Marcus. I will have a look at it
first because I am quite familiar with lingo and my other programming
experiences (the last have been miranda and modula3) are almost history
(3 years...).
Would you be so kind and provide me with the url to Davids Script?

so long,
Olaf

__
Olaf Schmidtmann
brainbits
online & cross media
mailto:os .AT. brainbits DO.T net / www.brainbits.net

> -----Original Message-----
> From: Scott Lawton [mailto:scott@catchmaker.com]
> Sent: Thursday, November 30, 2000 4:56 AM
> To: valentina .AT. lists DO.T macserve.net
> Subject: RE: AW: Building a vlb from an sql-dump or from csv-data
>
>
> >CREATE TABLE pr_scheinwerfer (
> > id int(5) DEFAULT '0' NOT NULL auto_increment,
> > pr_id int(5) DEFAULT '0' NOT NULL,
> > gewicht varchar(8),
> > breite varchar(8),
> > hoehe varchar(8),
> > tiefe varchar(8),
> > leistung varchar(10),
> > abstrahlwinkel_in_grad varchar(10),
> > farbtemperatur_in_kelvin varchar(40),
> > PRIMARY KEY (id),
> > UNIQUE id (id)
> >);
>
> David Bayly wrote a very cool script in Frontier that takes
> the following format as input:
>
> Customers
> Customer
> Name, string(30)
> Address, string(50)
> Photo, blob
> Invoice
> CustomerPTR, objectPtr(customer),
> deletionControl(delete_many)
> Date, date
> Total, float
>
> It might not be too much work to do a series of find/replace
> to convert from one to the other. There's a free version of
> Frontier 5, and you don't need to learn much of Frontier to
> be able to run David's script.
>
> Just FYI,
>
> Scott
>
>
>
> -------------------------------------------------------------
> The Valentina mailing list is brought to you by MacServe.net
> For info on lists services, see http://www.macserve.net/lists.html
>

-------------------------------------------------------------
The Valentina mailing list is brought to you by MacServe.net
For info on lists services, see http://www.macserve.net/lists.html
 
©2000 Olaf Schmidtmann
<-- Prior Message New Search Next Message -->