126 Topic by VascoMorais

(5 replies, posted in General)

hey guys, so my database currently has an invoice "part" that is working fairly well.
But sometimes i have to "manually" check if i have something in stock in order to see if i have to order a part or not.
I want to make a table for inventory, that works in conjuction with the inventory table, so once i add a specific item to the "invoice" sql table, i want the same quantty of items to vanish from the "stock sql table"
Also, i want it to be able to add stock back in case an invoice doesn't go through and gets canceled.

Can i follow an example from anyone so i can take any ideas?

Go to forum: General

127 Reply by VascoMorais

(3 replies, posted in General)

oh boy oh boy, here i go programming again!

https://i.imgflip.com/1urggi.jpg

Thanks guys!

Go to forum: General

128 Reply by VascoMorais

(4 replies, posted in General)

oh, very nice, thanks!

Go to forum: General

129 Reply by VascoMorais

(4 replies, posted in General)

Weird, only the font solution worked...
Many thanks EhWagner smile

Go to forum: General

130 Reply by VascoMorais

(4 replies, posted in General)

yes, on "on show"

Go to forum: General

131 Topic by VascoMorais

(4 replies, posted in General)

Hey guys, what am i doing wrong?
i want this to change color if both comboboxes are different.

begin
   if frmassistencia.cbcriacaolocal.dbItemID <> frmassistencia.cbtransferido.dbitemid
  then
  begin
  frmassistencia.cbcriacaolocal.Color := clred
  end;

Go to forum: General

132 Reply by VascoMorais

(4 replies, posted in General)

currently i am using sqlvalue from the selected record, but is there any other way to do this?

Go to forum: General

133 Topic by VascoMorais

(4 replies, posted in General)

hey guys, i need a way to "show" the current table id
In any other table entry i could just create a text box, and point it to the table.name but in case of table.id it doesnt' work, is there a workarround?

Go to forum: General

134 Topic by VascoMorais

(3 replies, posted in General)

hey guys, is there a way to "lock" table sizes in place? i have to readjust everything after i restart the app

Go to forum: General

135 Reply by VascoMorais

(3 replies, posted in Script)

Hey Dmitry, yes you are right, i have both relationships between tables, but table_1 doesn't even have any records for ID_Table2 .

OKay so here's my problem:

I have Table_Prices with various lines, each line corresponds to a  Table_Customer ID:

Line1 -     ID_Table_Customer         Price       Description Etc...

While Table_Customer i have

Name  Description Date etc... but no id relative to Table_prices because i have multiple lines to a single customer.

Is there a way to search for those lines in ID_Table_Prices using the date from Table_Customer?

Go to forum: Script

136 Topic by VascoMorais

(3 replies, posted in Script)

Hey everybody, i want to make a search , so i can search the invoices from a specific date, "From" and "To"

But here's the catch:

The Table that has the invoices, doesn't hold any Dates, it has an ID to yet another table, and this second table has the dates i need.

Example

Table 1

ID_Table2
Invoice Description
Prices
Etc...

Table 2

Something...
Something...
Dates <----
Something...
ID_Table1


Goal:

To search Table 1 , All Entries that have specific Table2_Dates

Go to forum: Script

137 Reply by VascoMorais

(5 replies, posted in Script)

thanks! i'm a bit rusty at this, what's the right code for .text "filled" ?

Go to forum: Script

138 Reply by VascoMorais

(5 replies, posted in Script)

i'm explaining this wrong

What i want to do is, create a procedure for some fields, that allows me to "ADD" text to another field:

Example:

form1_combobox1_onchange

add 'Combo1 has been changed' to form1.memo1.text



form1_combobox2_onchange

add 'combo2 has been changed' to form1.memo1.text

So when i click save, i'll also save the memo1.text and i'll ahve this:

Combo1 has been changed Combo2 has been changed

Is this porrible?

Go to forum: Script

139 Topic by VascoMorais

(5 replies, posted in Script)

Hi, is there a way to write something automaticly on a specific memobox? For instance


form1.memobox1.text = (action1.text) and (action2.text) and (action3.text)


if from1.checkbox.checked then
begin
action1.text = Person clicked on checkbox
end

procedure form1_combobox_onchange

action2.text = (person changed combobox to) + from1.combobox.text



This is just an example, probably i have syntax errors here, but what i want to make is create a history log.
Useful to see if people are "deleting" records or making mistakes

Go to forum: Script

140 Reply by VascoMorais

(13 replies, posted in General)

DriveSoft wrote:
VascoMorais wrote:

Hey Dmitry, this Tprint might be useful to set two different printers for different areas, looks good, but can i use it to print reports and sql reports?

No, TPrinter just for script.

Will you implement a way to choose between printers on print report?
I am building a database where you can print label stickers in the sticker printer, and A4 Reports on A4 Printer
If i could configure this at the push of a button it would be greaet

Go to forum: General

141 Reply by VascoMorais

(13 replies, posted in General)

Hey Dmitry, this Tprint might be useful to set two different printers for different areas, looks good, but can i use it to print reports and sql reports?

Go to forum: General

142 Reply by VascoMorais

(8 replies, posted in General)

Well.. bought MyVisualDatabase, now it's serious! smile

Go to forum: General

143 Reply by VascoMorais

(8 replies, posted in General)

clever!!

Go to forum: General

144 Reply by VascoMorais

(13 replies, posted in General)

hey dmmity, great job! what does Tprinter do?

Go to forum: General

145 Reply by VascoMorais

(8 replies, posted in General)

for instance Dmitry:


You have a combobox with the following items:


Fruit
Meat
Vegetables

And all of them are clickable ok?

But imagine that Meat has stock = 0

it will show

Fruit
Meat (grayed)
Vegetables

You can select Fruit and Vegetables, but not Meat now.

I could hide it with Filter Id_stock = <1 for example, but that brings us with another problem:

imagine that you want to see what someone had for dinner, and imagine he had choosen Meat, so you open the record that you had saved previsouly , and you will see the combobox "empty" or "unchosen" even tough the sql clearly has "ID 2" referenced to that combobox.

Go to forum: General

146 Reply by VascoMorais

(8 replies, posted in General)

oh wow! these look so much better, nice! thanks.
How about ghosted combo box values? is it possible to do so? not the combobox itself but a content in the combobox

Go to forum: General

147 Topic by VascoMorais

(8 replies, posted in General)

Hey everyone.

I Wanted to ask if there's these features present:

Possibility to wordward tablegrids, instead of having the text going from one end to the other, is there a chance we can see multiple line breaks on a single table row?

Making a ghost selection on Comboboxes.

EG:. Using a filter to make selections visible, but unclickable , very useful to avoid selecting items with stock = 0

Go to forum: General

148 Reply by VascoMorais

(3 replies, posted in General)

DriveSoft wrote:

it's rule of SMTP protocol, you can't change it.

but that's the reason why so many emails are unsuported, because the Sendmail command already adds the< >  signs automaticly.
Is there a way you can create a new sendmail command in the future with an option to excluse the automatic <> on email from name in the future? this way you can update myvisualdatabase to a future version without corrupting previous databases scripts.
For instance

Sendmail -n ' etc....

so you have to add "name <name@email.com>" manually, because in this case, if i write name <name@email.com> sendmail will send a request to the smtp server that the source comes from <name<name@email.com>> and that gives me an error everytime.

I know this because i had to setup an smtp server at home, to try and figureout what's wrong.

I've been trying to build a database to replace an old app i have at my store, but without this issue solved, i can't use what i've got unfortunatly

Go to forum: General

149 Reply by VascoMorais

(3 replies, posted in General)

After a bit of reseach i found out what's the bug with sendmail.


Send mails sends all email address with: <youremail@gmail.com>
It should be youremail@gmail.com without the <>

Dmitry, is there a way to configure the sendmail command so the sender name goes without <> if i don't want it?

Many thanks

Go to forum: General

150 Topic by VascoMorais

(3 replies, posted in General)

Hi there, i am reading about sendmail, and i can't make it work with gmail, or some other emails for this matter, sendmail is a simple command but i can't make it work, i read Dimitry talking about tidSMTP, maybe i'm missing that, what's that?

Go to forum: General