Mask in TfrEditControl

produsys

Hi,
I'm want to put a Date Mask into a TfrEditControl on Dialog! But I don't know how make this!! Somebody help me!! Please!!

Ps.: Sorry for my poor english!

gordk

why not use the dateedit control

produsys

This don't work for me!!
I'm want to make this for a Select in query where the date is greater than Edit2.Text and minor than Edit3.Text. Do you understand??
See my example code:

 Query1.SQL.Clear;
  Query1.SQL.Add('Select * from BUY');
  Query1.SQL.Add('where buy_code = '+Trim(Edit1.Text));
  // Here I have a if for check blank Edit2
  Query1.SQL.Add('and buy_date >= '''+Trim(Edit2.Text)+'''');
  // Here I have a if for check blank Edit3
  Query1.SQL.Add('and buy_date <= '''+Trim(Edit3.Text)+'''');
  Query1.Open;

It's for that I need the date mask, because if the user not type the date separator "/" or ".", mine Select returns null and the report... blank!
if my user not type anything, my Select will return all date. Understand??

gordk

so use 2 date edits parameterize your query and point the params
to dateedit.text then all your user has to do is pick the date, you can initialize the date value in the onactivate event of the dialog if you want to supply a default date.

produsys

gordk wrote:

so use 2 date edits parameterize your query and point the params
to dateedit.text then all your user has to do is pick the date, you can initialize the date value in the onactivate event of the dialog if you want to supply a default date.

How make the DateEdit be blank?? My Select may be affected if the DateEdit is filled with Default Date??

gordk

the initial value of a dateedit is empty, it just shows 2 separators.
typical query sql statement
SELECT DISTINCT OrderNo, ShipDate, Subtot, GstTotal, PstTotal, InvTotal, Posted
FROM "orders.DB"
WHERE
(ShipDate >=:from)
AND (ShipDate <=:to)
AND (Posted = 'TRUE')
ORDER BY OrderNo, ShipDate, Subtot, GstTotal, PstTotal, InvTotal, Posted

from and to are parameters
in designer select query in obj inspector select params
in params editor left pane select the parameter in the datatype select date
select value add dateedit1.text. repeat for next param using dateedit2.text.
you can also parameterize your other selection criteria the same way.

produsys

Thank You gordk, I'll test the DateEdit.

produsys

In my Fast Report the DateEdit is showing with the Actual Date, It cannot be set blank! How I make it?