Counter

[Guest_imported]

Hi,
I have developed a form where in user fills in the form.I want to track its count.I Have created a view where the values are stored.
I want that when a particular user fills in that form i should be able to search the database whether that particular name exists if it exists then it should increase its count & its value should be stored in view where i have two fields name & count.Name should go only once in view, it should only increase its count.
If the user is new then it should give its count as one.
View Should Be Like This
============================================================
Name Count
============================================================
User 5
Name 4
============================================================
can any one help
regards

 

[gamesman]

This is just a thought, because I haven't tried it but, IF notes odbc connections will allow you to access a notes db from within notes via odbc then;

you could create two columns/commands within a view. First column would be @dbColumn(odbc) with distinct keyword to retrieve your list of names. Second Column would be @dbCommand with a select count() SQL query based on the name found in the first column.

You can download the obdc drivers et al from notes.net and give it a try. You would have to use ODBC in this option because DBCommand only works in ODBC and the distinct option is only available with odbc.