|
|
Browse by Tags
- 2003
- 2007
- Access
- another
- block
- boot
- change
- check
- control
- copy
- count
- crystal
- current
- d2k
- data
- database
- date
- delete
- dlookup
- dns
- duplicate
- error
- excel
- exchange
- exists
- field
- fields
- file
- find
- first
- fix
- form
- forms
- formula
- found
- from
- get
- go
- godaddy
- group
- highest
- how
- id
- insert
- inserted
- invalid
- join
- last
- latest
- lock
- locking
- lov
- macro
- master
- most
- move
- MS
- multiple
- mx
- mysql
- new
- newest
- next
- nth
- number
- one
- only
- open
- oracle
- php
- position
- prevent
- previous
- ptr
- query
- recent
- report
- reports
- reserve
- retrieve
- return
- select
- selection
- sendmail
- single
- spf
- sql
- Subform
- table
- tlv
- top
- update
- value
- vba
- video
- webcam
- where
- windows
-
Get last inserted record
Hi I need to retrive the id (primary key and auto increment) of the last inserted rowso that i can ue that reference thru the is and i know we could do it using max function. But its not a reliable way when u consider multi user applications. Does anybody kno anything more relaible. How about UUID. Can... -
Checkbox update record
Is it possible to have a master page with a checkbox, that can update a record if selected? -
SQL Query to select last X records...
Hi experts, I need an SQL query (in MS SQL) to select last X records, for example my table has 1000 records, I want to select last 10 records. I know by using TOP I can do that, but it returns from first X records, not last X records. Also I do not want to use DESC ordering. Queries like: SELECT TOP... -
SQL Query to find last record
I need the syntax in SQL to find the last row in a database on SQL server 2000 -
Display Records Horizontally (withina fixed limit)
I need to display the first 10 records coming from my source in a horizontal fashion, rather than vertical. This seem far more tricky than it should be - in the very, very worst case, could I make a formula that shows me the nth field of a given record? This way, I could be able to create this layout... -
Help in the Record Selection Formula Editor.
I have a list of filters that I am passing to the report and I was curious if under the Record Selection Formula Editor I can do this, like standard SQL: // list of other criteria.... ... ... {MyViewTable.FieldName} in (SELECT number FROM otherTable) // I don't have that otherTable in the report... -
Select the TOP n Record From oracle
Hi How we can achieve the functionality of SELECT "TOP N" Records in ORACLE 8.1.7 -Edward -
"Invalid TLV record" error message, VB6 app with CR9
Any suggestions as to what to do about a custom VB6 app giving an "Invalid TLV record" error message? I had the client email me the report and tested if for corruption on my computer and it works fine. I created a small utility program to check the client's computer for the usual problems... -
Crystal Reports 8.5 get previous record based on date.
This is probably simple but I can't figure it out. I have a list of records based on a field called serialID. These records have a corresponding datetime field. I need to get the last (most current) record based on the datetime field and validate whether the status field has the number 1 in that... -
How can i get second last record from table?
How can i get second last record from table I have done this way is this always correct? SELECT TOP 1 ID FROM Table1 WHERE ID NOT IN (SELECT TOP 1 ID FROM Table1 order by ID Desc) order by ID Desc How can i assign ID to a variable for later use in stored Procedure.