Unsupported Screen Size: The viewport size is too small for the theme to render properly.

Forum Replies Created

Viewing 15 posts - 2,491 through 2,505 (of 2,527 total)
1 2 3 … 166 167 168 169
  • Author
    Posts
  • February 10, 2003 at 4:04 pm in reply to: Foreign keys #13694
    Ritesh
    Member

    Thanks for the idea.

    February 10, 2003 at 1:44 pm in reply to: new features & error #13690
    Ritesh
    Member
    Quote:
    The SQL editor haven't the capability to import a sql script. Now there is only the possibility to run a command without to see it before execute, or write a command and save it. (see Mysql front )

    You can open a SQL Script file in the editor, by using File->Open…

    If you want to execute a big SQL file as a batch file then use Tools->Execute Batch File…

    Quote:
    foreign key; Perfect to insert a new foreign key. But if I try to remove it I receive, before a message (confirm a drop relationschip) and after an error 1005 (can't create table c:winnttemp#slq290_1_3.frm (err.140). Note that there are all the permission in c:winnt folder. In the history windowd appear:

    Have you configured your MySQL server to be able to create temporary table? SQLyog is giving an error, because MySQL was not able to create the temporary table, which SQLyog needs for proper duplication of data.

    Quote:
    3) There is a editor for my.ini file ?

    Why you need that?

    February 10, 2003 at 1:33 pm in reply to: Synchronizatoin Feature #13691
    Ritesh
    Member

    Thanks for your idea.

    February 10, 2003 at 1:31 pm in reply to: Insert\Update Data Dialog #13693
    Ritesh
    Member

    Is it happening for all tables/data or for some particular tables?

    Quote:
    When I open the InsertUpdate data dialog and click on a field button? that contains data (as can be seen by the amount of bytes) the whole program crashes.

    Can you mail a sample data to [email protected] with the table structure so that we can work on it. It will be very helpful if you could give us the steps which will reproduce the error.

    February 9, 2003 at 11:50 am in reply to: limit in view data #13684
    Ritesh
    Member

    We are in the process of making SQLyog completely configurable in one of the future releases.

    February 9, 2003 at 5:44 am in reply to: limit in view data #13682
    Ritesh
    Member

    Go to the installation directory of SQLyog. You will find SQLyog.ini. In the SQLYOG section there will two fields LowLimit and HighLimit. Change those limits to reflect in SQLyog.

    As of now you cannot change it through SQLyog GUI Interface.

    February 8, 2003 at 3:02 pm in reply to: coping tables between two databases #13674
    Ritesh
    Member

    You can do that.

    Just connect to both the hosts, and select the table you want to copy in the Object Browser. Choose Copy Table… from the popup menu.

    You can copy structure as well as data between two databases.

    February 6, 2003 at 8:23 pm in reply to: Table Diagnostic #13670
    Ritesh
    Member

    Seems, the working of some SQL commands has changed in MySQL 4.01 😉

    February 6, 2003 at 6:31 pm in reply to: Table Diagnostic #13668
    Ritesh
    Member

    I have forwarded it to the development team and they are working on it. Probably we will come out with a solution soon.

    It will be very helpful, if you write the SQL yourself instead of using the GUI of SQLyog. If your table diagnostic SQL works then check out the difference between your Query and the one generated by SQLyog.

    February 5, 2003 at 5:47 pm in reply to: Error #13658
    Ritesh
    Member

    I received the DB you mailed me and I was able to import it perfectly. We have Access 2K but then I dont think it will be a problem.

    Quote:
    Now everything seems to goe thru OK, but only the field names show up with “data type” and “length”

    Are you talking about the Column Mapping And Transformation Dialog Box. If so then everything is OK because Access ODBC driver does not give information about Primary Key and other things. Only NOT NULL information are available and in our condition ID field of the database was a NOT NULL column.

    Send suppo[email protected] the screen shot the screen which you find is not up to the mark?

    Hope it helps

    February 5, 2003 at 9:43 am in reply to: Save import job? #13660
    Ritesh
    Member
    Quote:
    Is this forum moderated?

    Defintately, it is 😀

    Quote:
    It would be great to be able to create the job in the ODBC import wizard and have it save the job to a file that I can then schedule to run regularly, preferably from the command line or another method that allows the use of windows task scheduler and no user intervention.

    This feature is already in our TO-DO list and SQLyog will support it in one of the next releases.

    February 5, 2003 at 9:41 am in reply to: Error #13656
    Ritesh
    Member

    Hello vinique

    will it be possible to upload a sample datafile which we can test on our side to check if there any bug in SQLyog?

    you can mail them to [email protected], if you want?

    you have still not told us in which dialog you are getting the error? until you tell us we wont be able to help you

    February 5, 2003 at 4:45 am in reply to: Error #13654
    Ritesh
    Member
    Quote:
    Syntax Error in Query. Incomplete query clause.

    When are you getting this error?

    Can you tell the steps you are following before you face this problem? Probably then I will be able to help you?

    February 4, 2003 at 7:20 pm in reply to: SHOW DATABASES on Connect #13602
    Ritesh
    Member

    What all features you think are there in MySQL-Front and not in SQLyog?

    February 4, 2003 at 6:24 pm in reply to: Error 2003 #13645
    Ritesh
    Member
    Quote:
    The secion of the doc covering this problem

    There is a user post by Amy Law which deals with a similar problem. Check it out if you have the same.

  • Author
    Posts
Viewing 15 posts - 2,491 through 2,505 (of 2,527 total)
1 2 3 … 166 167 168 169