Re: [sqlite] need a CURRENT_USER() function

2009-01-16 Thread Alexey Pechnikov
Hello! В сообщении от Friday 16 January 2009 18:25:34 jose isaias cabrera написал(а): > Did not come attached... Will you send it again? Source: http://mobigroup.ru/dload/sqlite3.6.7/env.c Full source: http://mobigroup.ru/dload/sqlite3.6.7/sqlite-3.6.7.tar.bz2 Compiled:

Re: [sqlite] need a CURRENT_USER() function

2009-01-16 Thread jose isaias cabrera
Did not come attached... Will you send it again? - Original Message - From: "Alexey Pechnikov" <pechni...@mobigroup.ru> To: "General Discussion of SQLite Database" <sqlite-users@sqlite.org> Sent: Friday, January 16, 2009 5:47 AM Subject: Re: [sqlite

Re: [sqlite] need a CURRENT_USER() function

2009-01-16 Thread Alexey Pechnikov
Hello! В сообщении от Friday 16 January 2009 00:23:18 Hoover, Jeffrey написал(а): > Can anyone tell me set-by-step how to add a CURRENT_USER() function to > SQLLITE that will return the current linux login? See attached file. Best regards, Alexey. ___

Re: [sqlite] need a CURRENT_USER() function

2009-01-16 Thread Martin.Engelschalk
Hi Jeffrey, use something like this: struct passwd *who; if ((who = getpwuid(getuid ())) != NULL) { oUserName = who->pw_name; } where oUserName is the desired result. See http://www.sqlite.org/capi3ref.html#sqlite3_create_function how to define your function.

[sqlite] need a CURRENT_USER() function

2009-01-15 Thread Hoover, Jeffrey
Can anyone tell me set-by-step how to add a CURRENT_USER() function to SQLLITE that will return the current linux login? I'm not a C programmer and I have JUST picked up SQLite. I am trying to convert a Sybase schema to SQLite. The schema has triggers triggers but so far they convert in a