records

What is your programming record in a single sitting?

How long (in hours) have you coded in a single sitting (one session)? ...

What's a good program to record video or screencast being played on screen?

What's a good program to record videos or screencasts being played on screen? ...

Generating unique account numbers - recursive call

Hi i need to generate 9 digit unique account numbers. Here is my pseudocode: function generateAccNo() generate an account number between 100,000,000 and 999,999,999 if the account number already exists in the DB call generateAccNo() /* recursive call */ else return new accout number end if end func...

When you are abstracting your database records and datasets into objects, what does your object model look like?

I'm asking all of you who aren't using a library for this, but are constructing your own objects for managing data flowing to and from your database tables. Do I have a recordset object? one object per row of data? Both? Neither? Any suggestions or experiences welcome. Please don't tell me to use an ORM or other such toolkit. It's ov...

What is the syntax for inserting data into a timestamp(6) type field in Oracle

I need to insert some data into a table in Oracle. The only problem is one of the fields is a timestamp(6) type and it is required data. I don't care about what actually goes in here I just need to get the right syntax for an entry so that the database will accept it. I'm using the gui web client to enter data however I don't mind usi...

Can record field updates in OCaml be generalized?

I'm a very novice OCaml programmer so please forgive me if this is a stupid/obvious question. There's a lot to absorb and I may have missed this in the documentation. I have a base of code that's starting to look like this: let update_x p x = add_delta p; p.x <- x; refresh p let update_y p y = add_delta p; p.y <- y; refre...

How to count unique records and get number of these uniques in table using SQL?

Hi, Imagine I have table like this: id:Product:shop_id 1:Basketball:41 2:Football:41 3:Rocket:45 4:Car:86 5:Plane:86 Now, this is an example of large internet mall, where there are shops which sell to one customer, so customer can choose more products from each shop and buy it in one basket. However, I am not sure if there is an...

What is the difference between file and record in OS's view?

In terms of general operating system concepts , What is the difference between a file and a record? How the OS will manage them? I know what a file is and what a record is but how it is distinguished in an OS? ...

How to select a large amount of records in SQL SERVER

I'm trying to select more than 80,000 record in SQL Server in a table that has millions of records. The issue is that I've the correct Index, but it takes more than 15 minutes to return the recordset. I'm using MS SQL Server 2000, I found a pagination method using stored procedures but it uses a temporal table that I have to insert the ...

Counting no. of Delimiter in a row in a File in Unix

I have a file 'records.txt' which contains over 200,000 records. Each record is on a separate line and has multiple fields separated by a delimiter '|'. Each row should have 35 fields, but the problem is one of these rows has <>35 fields, i.e. <>35 '|' characters. Can someone please suggest a way in Unix, by which I can identify the r...

SQL Server 2005: Audit random record deletion.

This may seem like a dumb question, but I'm in a head-> wall situation right now. I work on a massive ERP application in which the SQL Server 2005 database is updated by multiple disparate applications. I'm trying to figure out where the deletes in a particular table are originating from. I tried using the Profiler but I'm not able to...

MSSQL record date/time auto delete

I want to delete records from a db table based on a time-stamp for each record. I would like to have it automatically delete records compared to a date/time interval without user intervention or admin intervention. What would be the best way to go about this, I could create a process that runs in the background that does checks but that ...

When to use Records Vs Objects

I use Delphi, but this is a question that I think is valid for any object-oriented programming language. When should I use records over objects. I used to think that you used records when you had some simple definition of a set of related data that you wanted to store together that didn't need to be able to manipulate itself. However e...

Is there an easier way to modify a value in a subsubsub record field in Erlang?

So I've got a fairly deep hierarchy of record definitions: -record(cat, {name = '_', attitude = '_',}). -record(mat, {color = '_', fabric = '_'}). -record(packet, {cat = '_', mat = '_'}). -record(stamped_packet, {packet = '_', timestamp = '_'}). -record(enchilada, {stamped_p...

"Left side cannot be assigned to" for record type properties in Delphi

Hi, I'm curious to know why Delphi treats record type properties as read only: TRec = record A : integer; B : string; end; TForm1 = class(TForm) private FRec : TRec; public procedure DoSomething(ARec: TRec); property Rec : TRec read FRec write FRec; end; If I try to assign a value to any of the member...

multi-user application record locking - best method?

I'm developing a php / mysql application that handles multiple simultaneous users. I'm thinking of the best approach to take when it comes to locking / warning against records that are currently being viewed / edited. The scenario to avoid is two users viewing the record, one making a change, then the other doing likewise - with the po...

LINQ - Does .Cast<T>() Select Records?

I've noticed that certain command cause LINQtoSQL to connect to the database and download the records that are part of the query, for example, .ToArray(). Does the command .Cast() cause a query to execute (and how can I tell these things in the future?). For example... IRevision<T> current = context.GetTable(typeof(T)) .Cast<IRevis...

When were extended records introduced?

In Delphi 7, you a record was nothing more than a collection of data grouped into one location. In the last few versions, you've been able to add public and private members, methods, properties and constructors to them, treating them a lot more like objects. What version was this extended syntax introduced in? EDIT: In case anyone won...

simple database handling applicatication with Kohana

Can somebody help me with database handling applications like insert a record, edit etc. ...

Subform only shows single record

I have a subform(Users subform) embedded in a form(users). What I am trying to achieve is on load, the subform should show ALL users in the table and the controls on the main form to act as a filter. i.e. if user A is selected from a combobox in the main form, only User A's details show in the subform if the selection (ie userA) is clear...