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 :)...
User Profile
Collapse
-
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...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... -
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,...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.... "Leave a comment:
-
Thanks Joe but this is not it.
You can do the same with MSSQL using
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.Code:Set @x = "Select your statement in here..." Prepare stmt as @x; Execute stmt;
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
-
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...Leave a comment:
-
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...
No activity results to display
Show More
Leave a comment: