Search results for query: *

As far I a can tell, there is nothing different from the one cursor I am using from the others being called in the program. That is why I am at a loss at to why it is not working. The new cursor is called/created the exact same way the other cursors in the program are created. I'll take Mike's...

Thanks for quick responses! Mike hit the nail on the head as to how the current function is working. The function using the CursorGetProp('tables') has been in place for some time and works perfectly with all other cursors being used except this one. I'm having to change a program to add...

I have a program where I am extracting the table name via CursorGetProp("tables"). I am processing approx 20 tables and this function works great on all tables except one. I cannot understand why this is not working for one table!! I far as I can tell, there is nothing different about this table...

Here is the solution I found for my issue. . . TheBugSlayer was correct and no matter how I executed the command in a stored procedure, the function performed correctly. I gave TheBugSlayer a big thank you star for confirming I was not off my rocker and my code was correct. The issue was...

Ok - back again. . . After applying all service pack updates, still receive the message. Any help would be appreciated. Thanks, KFlasph

I agree with TheBugSlayer. . .It actually does not return as a recordset but since the called proc in my program expects a recordset and error occurs with the message coming back from SQL. The stored procedure is only being called by one program run by one person at any time. After furter...

I have a stored procedure in which I reset the indentity field using the dbcc checkident ("TableName",reseed,0) command. Everything works as expected but I am having something strange happen with a few of my customer when they run the stored procedure. 99% are able to run the stored procedure...

Thanks for the reply ! I was doing the process the wrong way. I was doing my CTE select first and then trying to build the cursor from the results. The way you have it makes sense now - I was trying to put the cart before the horse. Thanks so much ! Star for you ! KFlasph

Since MicroSoft couldn't be convinced ; ) ... We went with the user just pressing Enter or "N" - I set the MsgBox to default to the No button when presented. Thanks for all of the responses

Thanks for the input - I was hoping there was a way to do this without having to build a custom form. Thanks again, Kflasph

They want to be able to press the Escape button sooo If I capture the keystoke - how do I relate it to the Message box? Kflasph

I have a basic Yes No message box where I would like the user to be able to press escape when the message box appears as a 'No' answer. Is there a way to do this ? Kflasph

I ended up creating a temp table to hold the values but I was just wondering if it could be done. Thanks for the quick responses ! KFlasph

I have built a Common Table Expression that gives me the results I need and I would like to loop through the results to run other selects with each record. Is it possible to create a cursor with the results of a CTE? I can run the CTE then select the information from the table in a simple...

Again ... Thanks so much for the help ! Kflasph

Okay this is probably one of those " You should have said that to begin with ". My form is a mdi child so when the form is launched, the parent top level menu is displayed at the top of the form. When I added the Popupmenu to the child form, the top level menu disappeared and it is blank where...

Thanks for your help ! KFlasph

I only have the one menu item with the children under the item - I checked just to make sure ;) I didn't know if maybe there was something I could set when the form is loading to suppress it. KFlasph

Let's say I don't want to do that. . . is there any other way to remove the line ? Kflasph

I have a program that I created a PopupMenu for so when the user does a right click - there are options they can select. The question is : In order to create the PopupMenu, I created a menu for my form and then made parent for the menu options disabled and not visible. When the form is...