1

(1 replies, posted in General)

Hi,
I am a private person who uses the program just for fun. I have two computers that a use (upstairs and downstairs)
Is it okay to use my license on both computers,

2

(6 replies, posted in Script)

Hi, Derek

Thank´s for your answer.

I store the filename in my table. So i use it to load the image on "Form1_OnShow" event. It works fine.

The viewer problem i solved with a "zoom" -button calling up an external viewer for my image.

Cujos

3

(6 replies, posted in Script)

Hi,

I've done some research

If i load the file with the forms OnShow event. The images is loaded but the view function does not work.

With the 'Open' icon on the DBImage1 Object  the image is stored in the database even if i have "DBImage1" "Type" set to "LinkFile", Right?

Is that an explanation why the View function does not work?

Regards

4

(6 replies, posted in Script)

HI, again

Here is the zip. i Have included a image that hopefully describes what i´m after.
The script on 'Form1.Button5" does the work.

5

(6 replies, posted in Script)

Hi,

I Store images in a "DBImages" object and set the "Type" to 'LinkFile'.
In my application i rename files on disc to a unique filename and then i want to load it in to my "DBImages" object.
When i do this the image displays correctly, but... When i save the form and open it up again, the image is gone..
It works if i set the 'Type' to 'StoreFile'

What am i doing wrong?

6

(8 replies, posted in General)

Hi, again Derek.

As a said i started to rebuild the application it from scratch. I´m just about ready and now everyting works fine.

So i think we can stop wasting time on that old application. I must have made som errors when it was developed.

Thank you so much for your help, much appreciated....

There is a big "risk" that you will hear from me again :-))

Cujos

7

(8 replies, posted in General)

HI again, Derek

Thanks for some greate tips...

But the main problem still exists, i only have '0,00' in the cost column.
The strange thing is, If i use the typ-ahead search it finds my values???

I think i start from scratch with a new application...

8

(8 replies, posted in General)

Hi again Derek...

Sorry to say, i can´t get it to work. The only time i can see the value is if i do a search and de grid generated from the search-button shows it.
all other grids show '0.00'

It seems like there is some old fields an values in the database. If i sort the column named "Belopp" the one vith 0.00

Is there a tool for cleaning up the database?

A strange thing is, if i sort the column with the '0.00' the '0.00' does not show up together as they should.It seems that there is some old values or referenses sorted in the column.

I remember that i did a misstake earlier. I changed my cost-field from REAL to CURRENCY and i think it stopped to work after that.
Maybe som inconsistensy with fieldname and/or control names.

I am sure there is a lots of things to do in a different way, but i am a newcommer spendig approx 10-15 hours with the program, so....
I am waiting to get warm, and ivé seen the potential in software. I like it very much. You have made a greate job.

Cujos

9

(8 replies, posted in General)

Hi, Thanks for your answer... And it sunday and everything. You are doint a great job.

Ok,


The language in the application is swedish, so i hope you can understand the meaning In spite of that.

The file was to big to upload so....
Ekonomi.zip - 5.0 MB

10

(8 replies, posted in General)

This is very strange.

I have a grid displaying records including one column named 'Cost'.

The field is of type "Currency". In my form i can type in 166.00 an save the record. When returning to det grid it diplays 0.00 instead of 166.00??
If i type in 166.00 and search for it, it display the values correct in the same grid. What am i doing wrong?

I have included three pictures explaing the above.
Pic1 - The grid with columns and search bar.
Pic2 - My main form
Pic3 - The search result.

11

(5 replies, posted in General)

Ok, Derek... Thank´s

12

(5 replies, posted in General)

HI, and thanks for the answer Derek..

If i put my problem into your example it would be like selecting two values  (Receipt and Invoice) from the ComboBox, and that isn´t possible, or?

But now i have solved it. The filter formula looks like this (Typer.typ = "Receipt") OR (Typer.Typ = "Invoice"). My beginners misstake was that only the radiobutton "Show child records (if present)" was on.

Sorry for that...

13

(5 replies, posted in General)

Hi,
Maybe a silly question, but i can´t get around it.

I have a field "Types.type" and in the grid i want to show only records containing "Receipt" or "Invoice" in that field..

My filter formula is Types.type = "Receipt" it shows records containing  that fieldvalue.

But i really need en logical operator so i can select both "Receipt" or "Invoice" ---> Types.Type = "Receipt" or "Invoice"

I have tryed everything and i skimmed through your forum, but i didn´t find anything.

Thank´s in advance

14

(2 replies, posted in Script)

Hi, again...
After reading the forum i have solved the problem... So you can close this topic

15

(2 replies, posted in Script)

Thanks for your answer.

I have included a picture explaining what i want to do

16

(2 replies, posted in Script)

Is there a way to start a application with a filename stored in my database.
In my media database i need a "Play" button that launch my videoplayer software with my database field "FileName" as argument.
I don´t want to store my mediafiles in the database itself.
I have tryed with the FieldType "File", but that field does not show up in the "FieldName" Properties when i try add it to my form.