Search results for query: *

I get errors while trying to open a recordset when it has a "create user...." statement in it. The error is: 3704 Operation is not allowed when the object is closed. The create user statement works, because I have cut it and pasted it into SQL+ and it executes properly. The...

Does anyone know the script to send an email within InterDev? I wish to notify myself and a few others everytime information is entered into one of my databases via InterDev. Is there a script I can add to the submit button to email a notification of an added record? Kevin

I have figured out my error. In the RecordSet, the automatically open the recordset check box was checked. I unchecked it and all is well. Thanks for replying. Hopefully this might help someone else out there. Kevin

I realize that I can't create a duplicate primary key, but the question I have is, I can do the exact same update if I scroll to it through the navbar. As soon as I use the search script to find a record I get this error. Why does it give me this error when searching, but not when using the...

I have successfully created a page that can step through a database with a navbar. I can then edit or delete the item that I am at. This is all done with design time controls. I now would like to be able to search by name. I have made this work by using a script that takes a txtbox variable...

Does anyone have a suggestion on a good InterDev book? Right now I am using Visual InterDev 6.0 Programmer's Guide. So far I am not thrilled with this book. It seems really incomplete. Visual InterDev Unleashed is on sale at a local book store. Anyone know if this book is any good? Kevin

What you said makes perfect sense, but how do I go about keeping the same query for the navbar to use. Shouldn't this statement change the SQL statement: >rsITSxxx.setSQLText(newSQL) Why does it revert back to the original query statement every time it goes to the server to query the...

After bouncing this off other co-workers, I have found an answer. Interdev uses FormatDateTime(date,0). 'Now' can be substituted for Date for the current date. '0' is general formatting that works best with Oracle. The code I used to make it work looks something like this: getcurrentdate =...

I am trying to be able to let users do a search for a name in a database. If the name is partially correct (for example names are Zwork, Ztest, and Zbob. and they just typed 'Z') I would like them to be able to step through a list. I already have a recordset that can be navigated by a...

I used a Form Manager to manage the updates and inserts. Upon click of the save button I tried to have txtTime.value = sysdate. This does not work. However, when I manually type in a date into txtTime.value It works fine. Any more suggestions would be appreciated. Thanks for the help. Kevin

unfortunately, I am not using SQL Server. All of the data is being stored in an Oracle database.

I successfully inserted information into an oracle database, but I want to insert a date/time stamp to tell me when they insert the data. I have a column created in Oracle with the 'date' format. Is there a script I can write for this, or is their a function that will do it for me in VID? Thanks

I am new to VID and am confused on trying to make a parameterized query. I want to retrieve data that matches the name from a textbox. The recordset is working properly and is called rsITSxxx and it usess a SQL statement that is simply: select * from itsxxx. I also have a text box called...