Your 3 DREAM FEATURE for Vstudio ?

[Heinrich Ruoff]

On 6/18/05, Ruslan Zasukhin <sunshine at public.kherson.ua> wrote:
> On 6/18/05 3:25 PM, "Heinrich Ruoff" <heinrichruoff at gmail.com> wrote:
> 
> > ok got it - Load SQL only works when there is a Database already opened
> 
> Jochen, I believe this is not correct.
> 
> LoadSQL -- do not require existed Valentina db. It create new fresh.
>     so dialog must ASK user where to put new db.

with Valentina Studio 2.0b8 nothing happens pressing Load SQL
when no DB is already opened
thats why I thought the feature is not implemented yet

> 
> > but it doesn't seem to work with my .sql file created for mySQL
> 
> Is this file in the UTF8 ?

it is UTF8

> 
> Then yes, Jochen should add parameter ENCODING for this dialog.
> 
> 
> > is there an option to import .sql files to an existing Valentina DB?
> > Load SQL always asks for a new filename
> 
> Into existing .... We have such option for XML load...
> 
> For SQL not remember. Does mySQL allow such operation ?
> In the LoadDump() method we have parameter
> 
>     kStructureAndData, kDataOnly, kStructureOnly.
> 
> I do not see problems implement that if you point kDataOnly,
> Then just ignore CREATE TABLE commands, and execute only inserts...
> 
> -----
> Aha, I have remember one point.
> 
> For Relational model it can be danger import into EXISTED db that already
> have records, because you can get not-unique kees or Forein keys...
> 
> You see?

ok - makes sense
it would not be a problem for my current project 
to load everything instead of just the changes

Heinrich