[rbma]

Ritesh wrote on Jul 29 2005, 06:55 PM:

Can you attach or mail me the table structure?

[post=”6639″]<{POST_SNAPBACK}>[/post]

Attached.

[rbma]

peterlaursen wrote on Jul 29 2005, 06:31 PM:

but it exexutes correctly from commandline ??

Yes.

[rbma]

Ritesh wrote on Jul 29 2005, 06:26 PM:

What happens if you manually put the where clause in the XML file?

[post=”6633″]<{POST_SNAPBACK}>[/post]

It is saved in the XML file but will be truncated when you edit it again.

[rbma]

Ritesh wrote on Jul 29 2005, 06:21 PM:

We dont have any known limits in SQL WHERE clause. Can you cut-n-paste the where clause?

Accounting=1 OR Billing=1 OR Collections=1 OR Computer_Office_Furniture=1 OR Computer_Hardware=1 OR Computer_Software=1 OR Computer_Support=1 OR Consulting=1 OR Office_Equipment=1 OR Radiographic_Equipment=1 OR Radiographic_Film=1 OR Financing_Lending=1 OR Medical_Business_Forms=1 OR Insurance=1 OR Investments=1 OR Financial_Management=1 OR Personal_Management=1 OR Professional_Staffing=1 OR Service_Bureau=1 OR Office_Supplies=1 OR Radiographic_Supplies=1 OR Benefit_Packages=1 OR Publisher=1 OR Marketing=1 OR Other_Desc!=''

[rbma]

peterlaursen wrote on Jul 29 2005, 05:10 PM:

The failure to read SQL_WHERE is fixed in beta6.

Is there a limit on the number of characters? I have a long statement that is being truncated.

[rbma]

peterlaursen wrote on Jul 29 2005, 05:56 PM:

It is an issue with the ODBC-driver, I believe!

When I for instance

1)export from Access to MySQl using the MyODBC driver

and

2)import with SQLyog using the M$ ODBC driver for Access

… I won't always get the same datatypes

Timestamp is also affected.

peterlaursen wrote on Jul 29 2005, 05:56 PM:

Which DB are you importing from and to and which ODBC driver do you use ?

MSSQL to MySQL.

ODBC driver that came with Windows XP

[rbma]

peterlaursen wrote on Jul 29 2005, 05:37 PM:

Am I wrong thinking that it was you that requested a select all/unselect all functionality in the ODBC wizard ?

[post=”6620″]<{POST_SNAPBACK}>[/post]

Yes it was I but it was for to select/unselect fields in the Transform window.

[rbma]

peterlaursen wrote on Jul 29 2005, 05:10 PM:

The failure to read SQL_WHERE is fixed in beta6.

It is fixed. Thank you!

peterlaursen wrote on Jul 29 2005, 05:10 PM:

You also had your select/unselect all request …

This is for???

[rbma]

How about an option for Word Wrap?

[rbma]

Ritesh wrote on Jul 28 2005, 05:49 PM:

Is there any particular requirement for the feature?

It would be a trivial feature to add in BETA 6.

[post=”6609″]<{POST_SNAPBACK}>[/post]

No. Thank you.

[rbma]

peterlaursen wrote on Jul 28 2005, 05:24 PM:

there is not a SJA-process running in background (check taskmanager)

This was it. Thanks.

[rbma]

peterlaursen wrote on Jul 28 2005, 05:19 PM:

That's the same here with Beta5 – SQLWHERE does not show up in SQLyog GUI.

Will this be fixed?

peterlaursen wrote on Jul 28 2005, 05:19 PM:

But if you edit XML-file in Notepad and execute it from commandline does it then work as it should ?

Yes

[rbma]

Also can't overwrite an existing saved session. Here is the error message.

Could not create JOB file.

32: The process cannot access the file because it is being used by another process

[rbma]

Started from scratch. The value in the 'SQL Where' doesn't show up when editing a saved session.

4.1 Beta 5

[rbma]

peterlaursen wrote on Jul 28 2005, 05:03 PM:

which program did you use for editing ?

SQLyog

[Author]

Posts