as i know, there
is no way to return MD5 result back to its original value. Is this
true or not ?
Thanks a lot
On Aug 14, 2009, at 11:21 PM, Christopher Browne wrote:
hengkyliwand...@gmail.com (Hengky Lie) writes:
Anyone know what function i can use to encrypt / decrypt field or
record
Hi,
Anyone know what function i can use to encrypt / decrypt field or
record ?
When record saved, it saved in encrypt format. When i need to read
data, i just call decrypt function.
I am using MS Access 2003 and Postgresql 8.3
Thanks a lot.
Regards,
Hengky
--
Sent via pgsql-sql maili
but using query with an
updateable result.
Any suggestion ?
Thanks in advance
Guillaume Lelarge wrote:
Hengky Lie a écrit :
This is the same as what i think but the table has primary key and has
no relation to other table. This is the table definition :
[...]
These query result non
Dear friends,
I really amazed with this problem and need your help.
I run simple query from Query window of PgAdmin3: SELECT * FROM mytable
limit 10;
and the result are NON UPDATABLE QUERY, while i need the result are
updatable.
I run the same query from Passthrough SQL in Microsoft Access
;NF";"Non Food";3960.00;4200.;240.
Thanks for any suggestion.
Regards,
Hengky
Richard Huxton wrote:
Hengky Lie wrote:
Dear friends,
Hello. Quick tip - don't reply to another message when starting a new
thread, people will ass
Dear friends,
I have problem in postgresql view. This is the view (Pay attention to
the red and blue colours):
SELECT tblpenjualan.tanggal, tblpenjualan."operator",
tblpenjualan.noinvoice, tblpenjualan.bayar, tblpenjualan.bayarvocher,
tblpenjualan.jam, tblpenjualan.id, tblpenjualan.jeniscar
+0800 mailte Hengky Lie folgendes:
> CREATE RULE "rule1" AS ON INSERT TO "public"."tblmasdbt"
>
> DO (insert into tblmasgl (KODEGL,NAMAREK) VALUES (new.KODEGL,
new.NAMAREK));
>
>
>
> But I always get this error :
>
>
> ERROR: column
Dear Friends,
I have problem with rule and tried several times to solve it but not yet
success. Hope someone can help me.
I have 2 tables : tblmasdbt and tblmasgl.
I want on every record insertion in tblmasdbt, that record also
automatically insert into tblmasdbt. I need only 2 relate
Dear friends,
I am a new user to postgreSQL and really need help to solve my "stupid ?"
problem.
I have created function with 4 arguments like this :
CREATE OR REPLACE FUNCTION "public"."fHistoryCard" (begdate date, enddate
date, ProductID varchar, storeID varchar) RETURNS SETOF "publi