Hi all,

I'm having an unusual problem trying to delete an edittable row using Send_Message.

Here's the code, which is being executed from a stored procedure on the forms write event:

LOCATE '8' IN DEDUCTION_CODES USING @FM SETTING DEL.POS THEN

Send_message(CONTROLNAME,"DELETE",DEL.POS)

END

The problem is, if DEL.POS is 1 (row 1 in the edittable), I get a Windows error message "oinsight - an error has occurred in your

program " then asks me to close or ignore. If I choose ignore, the row DELETE actually occurs o.k. If the row to be deleted is at any other row but row #1, the row delete works fine and no error message comes up.

Any thoughts? This one is driving me batty.

OI 3.61 on Window 95, single user - no GFE's on any files.

TIA

Gene

Gene,

Can really one use periods in variable names (DEL.POS)? Try without.

- Oystein -

Oystein,

I have been using periods in variable names without any problems so far. If this is a no-no, I need to start changing them now! (Bonus question… :), do you know of any OI utility similar to AREV's FINDSTRING that will identify all occurrences of a string of text in a OI file? Scanrepos does not appear to have the same kind of functionality…).

In a last attempt to 'fix' this, I deleted the edittable from the form, then added it back.

Problem gone.

Thanks for your help.

Gene

Gene,

I have been using periods in variable names without any problems so far. If this is a no-no, I need to start changing them now!

Don't really know. Never used dots myself and cannot remember having seen variable names with dots in them. Or perhaps in RBASIC code (Arev), but not in BASIC+ (OI). I have hard time remembering back even a few years (when I used Arev).

Tried to check the OI online docs, but cannot find anything on legal characters in variable names. E.g function names are mentioned but not variable names as far as I can see.

If dots are allowed in variable names in Arev, and people regularly use them, they are probably allowed in OI too. Or else I'd noticed postings warning people to avoid them. There's been several posting warning people off using dots in table and field names. That's allowed in Arev but not always healthy in OI.

(Bonus question… :), do you know of any OI utility similar to AREV's FINDSTRING that will identify all occurrences of a string of text in a OI file? Scanrepos does not appear to have the same kind of functionality…).

I don't know FINDSTRING. But I think there is a way to achieve this in OI, something fairly simple. I seem to remember reading a posting some time. I might even have it somewhere in my vast electronic collection of possible useful stuff, but I don't know how to find it! Ironic or what?

But I'm certain somebody else can and will help you with this.

Btw - is it any substring you want to find, or is it any word?

And is it data tables or system tables you want to search?

I often have the need to search my own source code. What I have done is to write a simple export utility that writes all source to text files, and then I open and search the text files with a word processor. The utility writes all rows in SYSPROCS to one file, all rows in SYSREPOSEVENTS to a second file, and all the symbolic formulas of all the data dictionaries to a third one.

In a last attempt to 'fix' this, I deleted the edittable from the form, then added it back. Problem gone.

If only everything were as easy as that! "I had this terrible sprained ankle, but I just deleted the leg and added it back and now I'm ready to run again!"

- Oystein -

Gene,

You cannot add and remove columns from an edit table that has max rows set to -1.

Cameron Purdy

Revelation Software

Cameron,

AFAIK he's deleting rows, not columns.

[email protected]

SRP Computer Solutions

There is a form exe called FINDINFILES, bring it up in the Aplication Manager View and shift double click to run.

Barry

Barry,

There is a form exe called FINDINFILES

Not in my 3.61. Later version necessary, or did you get it from somewhere else?

- Oystein -

Hi Oystein,

FINDINFILES is one of my earlier creations that was available on CompuServe.

Title   : Find In Files utility for OpenInsight

Keywords: SEARCH FIND FILES NATIVE TABLES OI UTILITY

(Forms and source included)

This utility searches OI files for a specified string and sports a

record viewer that supports multiple formats (binary, plain text, and text

with most standard delimiters).

Note: Intended for 800x600 resolution or higher.

* cp 02/26/96

Cameron Purdy

Revelation Software

Cameron,

A very satisfying utility indeed! Thanks a lot!!

- Oystein -

Oystein,

Does that have an "Edit", "Find" menu item? If not, I have a newer version.

Cameron Purdy

Revelation Software

Cameron:

In the zip file… after attaching the *_TEMP files, do I need

to copy all the records in all the *_TEMP files into the normal

SYS… files to run the form ??? In other words, after attaching the

zip subdirectory how do I get your App to run?

Steve C.

Steve,

That is a Repository Checkout. Check-out, copy from. Specify the dir containing the TEMP files.

Cameron Purdy

Revelation Software

Cameron,

Really nice. Note that it does not have an "Edit", "Find" menu item?

If you could provide the newer one in the WORKS download section

it would be great…

By the way… I had tried a check-out but was in my APP, not SYSPROG.

Thanks again..

Steve C.

Cam

That was the old version of FindInFiles.

Barry

I quite liked it.

Does the newer version find more occurrences?

- Oystein -

Oystein,

Does the newer version find more occurrences?

The new one is so good, it finds everything.

Cameron Purdy

Revelation Software

Buttttttttt Cameron:

Where is this fantastic new FINDINFILES????

Thanks

Steve C.

P.S. Have you had a chance to think about how or if a

bitmap background can be used with a groupbox?

Really? I seem to have lost my mind somewhere back…

[email protected]

View this thread on the forum...