User Profile

Collapse

Profile Sidebar

Collapse
antmail
antmail
Last Activity: Jun 23 '08, 10:32 AM
Joined: Jun 25 '07
Location: Anywhere
  •  
  • Time
  • Show
  • Source
Clear All
new posts

  • Sorry, also see where the confusions comes in. The that was refered to in the original post was to show a sreenshot of the problem and is NOT part of my code.

    I have a straight forward windows application with one main form and a sub (child) form loading with in it.

    Hopefully that is as clear as mud :)...
    See more | Go to post

    Leave a comment:


  • I don't have an image on the form. It is only a form with buttons and some groupboxes.

    When I the form directly as an parent and don't dock.fill it, it works fine, but otherwise it is a problem.

    And no, I don't use css...
    See more | Go to post
    Last edited by antmail; Apr 29 '08, 04:01 PM. Reason: Spelling mistakes

    Leave a comment:


  • Resizing problem of a form if it is a child of a panel

    Hi,

    I have been struggling with this problem in C# for a while.

    I have created a form with about 4 panels on it. The main panel is set to fill the screen when it resizes. (Panel1 = Dock Top; Panel2 = Dock Bottom; Panel3 = Dock Left; Panel4 = Dock Fill)



    I have another form that I add to this panel 4. The problem is that if I have it open up as part of the form (child form), it resizes...
    See more | Go to post

  • Ok Guys,

    I thought I reached the end of the internet, but it seems there was more.

    The long and short of it, is that you can only do what I wanted do (dynamic SQL) in the upcoming version 5.1 of MySQL.

    When concatenating values in pre-5.1 versions, it does not resolve the table or column name but either gives an SQL error or sees that value as a literal string.

    So the only way to do this,...
    See more | Go to post

    Leave a comment:


  • Is the only way to do this using the exec method?

    I am familiar with that, but found it very difficult to debug when you get one of those mystery SQL errors.

    The statement I listed is one of the small ones, I have another even more complex and I found it very difficult to debug using set @x = "Select.... "
    See more | Go to post

    Leave a comment:


  • Thanks Joe but this is not it.

    You can do the same with MSSQL using

    Code:
    Set @x = "Select your statement in here..."
    Prepare stmt as @x;
    Execute stmt;
    However my problem is not executing but concating the string. I either end up with a literal string in stead of a table name or I get an SQL statement error, and we all know how helpful that error descriptions are.
    See more | Go to post

    Leave a comment:


  • Concat variable to form Table name inside Select statement

    Hi guys,

    I have spend several days now trying to solve this problem inside a stored procedure. I want to call a procedure providing 3 variables. The variables area used to select the appropriate table from within the database. I have to concatenate the 3 variables to make up the whole table name and concatenate that with the field name.

    The hard coded procedures looks as follows:

    Code:
    DROP PROCEDURE
    ...
    See more | Go to post

  • antmail
    replied to Undo changes in a Sub Form
    Thanks Hyperpau,

    It's not what I wanted to hear, but suspected. Hope Micro$oft gives us more control over that in Access 3020.

    I actual started doing quite a bit of the things you suggested. But the process got so complex in manageing all scenarios, and seeing that this is an intrim solution until a proper web application has been developed, I decided not disallow edits on the subform.

    I am creating a...
    See more | Go to post

    Leave a comment:


  • antmail
    started a topic Undo changes in a Sub Form

    Undo changes in a Sub Form

    Hi Guys,

    Been using this forum to get my answer for quite a while now, but finaly I am stumped.

    I have a form with a subform. I control on the main form when the data is saved and when it is discarded.

    However on my subform, if change is made, I cannot undo that change if the user press the cancel button on the main form.

    I am trying to use the same cancel button for both forms, as the...
    See more | Go to post
No activity results to display
Show More
Working...