Insert (Null)

[JohnFabrega]

I am trying to create a form and/or browse to update an active link SQL table.

The A5 documentation indicates that A5 'does not really have the concept' of NULL, however, apparently the underlying app requires that in certain cases, NULL must be used.

In SQL Enterprise manager, a NULL can be inserted using CTRL-0.

Is there a way to replicate this in Alpha?

Attached is a screen shot of the browse with the (Null).

Please understand that I am not a professional programmer and am just starting to work with active tables.

[Stan Mathews]

Re: Insert (Null)

Have you tried

null_value()

?

[JohnFabrega]

Re: Insert (Null)

Thanks for jumping in Stan.

Are you saying somehow create a script that would use that command to populate the field that currently has focus in a browse or form?

[Stan Mathews]

Re: Insert (Null)

If you want to put a null into a form field whose object name is

name

I would code a button with

name.value = chr(0)

for a character field type.

[JohnFabrega]

Re: Insert (Null)

I hope this doesn't sound too dense. You might be surprised at what I've been able to develop without much help, but I'm having problems wrapping my mind around this one.

Let's say I have a record in the form. There are a few fields that might have either data or null.

I would create a button related to each field that would cause that field to be updated with a chr(0) 'null'?

Sounds pretty straight forward if I'm getting it.

[MikeC]

Re: Insert (Null)

In addition to this, I seem to remember that to set a numeric to a null value you don't use the number_field.value, but number_field.text="" .



EDIT: this is the way within Alpha and if this script is to be used for the SQL side then whatever the syntax used in SQL would have to be used....my two cents might be worth less than a cent in this case!! :)

[Stan Mathews]

Re: Insert (Null)

I hope this doesn't sound too dense.

Not at all, I don't have a clue about working with SQL Enterprise manager so I don't know whether this will work the way you want.

Let's say I have a record in the form. There are a few fields that might have either data or null.

I would create a button related to each field that would cause that field to be updated with a chr(0) 'null'?

You could create a set of buttons or one button that nulled several field objects.

name.value = chr(0)
address.value = chr(0)
type.value = chr(0)

Understand that I am just guessing that this might work.

[Michael Humby]

Re: Insert (Null)

I have just done a search on "NULL Selwyn" and it has brought up lots of posts on this subject.

I will shortly be needing the same information as we are in the process of active linking to Mysql etc

Michael
www.instantnurserymanager.co.uk

[JohnFabrega]

Re: Insert (Null)

I should have broadened my search. I tried SQL NULL and got almost nothing.

I'll give Stan's suggestion a try and report back on my results.

Thanks!

[Vince McGinnis]

Re: Insert (Null)

John,

No need to go through all this work.

Re-establish your active-link table (re-do the link)

Under the Active Link "Options" screen find "Miscellaneous"

Un-check the option: Show blanks instead of (NULL)

This will put the (NULL) 's in for you.

[Vince McGinnis]

Re: Insert (Null)

John,

I need to add something here...

Actually you don't need to re-do the link. You can right-click on the active link table and edit the link definition.

Then UN-check the "Show blanks instead of (NULL).

Note: Most all of my links are to MS Access tables, I believe there is no difference in the options for linking to a SQL Table.