how to calculate record size in mysql
- by Osama
How to get the size of a record in MySql if the table contains fields of type TEXT or BLOB?
Search Results
Search found 6399 results on 256 pages for 'record'.
Page 16/256 | < Previous Page | 12 13 14 15 16 17 18 19 20 21 22 23 | Next Page >
-
-
Finding One record from table having unique PK and duplicate FK
- by Muhammad Kashif Nadeem
I want one record from a table having unique Primary Key and duplicate Foreign Key Please see attached image below ThanksRead the article
-
Daily/Weekly/Monthly Record Count Search via StoredProcedure
- by user270960
Using MS SQL Server.I have made a Stored Procedure naming "SP_Get_CallsLogged". I have a table named "TRN_Call", and it has one column named "CallTime" which is a DateTime. I have a web-page in my application where the User enters:- 1.StartDate (DateTime) 2.EndDate (DateTime) 3.Period(Daily/Weekly/Monthly) (varchar) (from DropDownList) I want…Read the article
-
How to manage multiple versions of the same record
- by Darvis Lombardo
I am doing short-term contract work for a company that is trying to implement a check-in/check-out type of workflow for their database records. Here's how it should work... 1) A user creates a new entity within the application. There are about 20 related tables that will be populated in addition to the main entity table. 2) Once the entity…Read the article
-
AVAudioRecorder prepareToRecord works, but record fails
- by iPadDeveloper2011
I just built and tested a basic AVAudioRecorder/AVAudioPlayer sound recorder and player. Eventually I got this working on the device, as well as the simulator. My player/recorder code is in a single UIView subclass. Unfortunately, when I copy the class into my main project, it no longer works (on the device--the simulator is fine). …Read the article
-
iPhone Development - Using NSPredicate to retrieve most recently added record from CoreData
- by Mustafa
I want to retrieve the most recently added record from CoreData. I was wondering if that's possible using NSPredicate? If so, how? e.g. i have a one-to-many relationship between Department and Staff, and i want to fetch the Staff record that was most recently employed. The Staff table has a date field which can be used. I don't…Read the article
-
Writing datatable to database file, one record at a time in C#
- by Kevin
Hi! I want to write a C# program that will read a row from a datatable (named loadDT) and update a database file (named Forecasts.mdb). My datatable looks like this (each day's value is a number representing kilowatts usage forecast): Hour Day1 Day2 Day3 Day4 Day5 Day6 Day7 1 519 520 524 498 501 476 451 …Read the article
-
Record locking problem between linux and Windows
- by PabloG
I need to run a bunch of old DOS FoxPro / Clipper applications in linux under DOSEMU. The programs access their "databases" located on a network server (could be a Windows or Linux server) Actually, the programs ran fine, but I cannot manage to make the record locking work as supposed: I can run a program in two terminals (or the…Read the article
-
Writing datatable to database file, one record at a time
- by Kevin
I want to write a C# program that will read a row from a datatable (named loadDT) and update a database file (named Forecasts.mdb). My datatable looks like this (each day's value is a number representing kilowatts usage forecast): Hour Day1 Day2 Day3 Day4 Day5 Day6 Day7 1 519 520 524 498 501 476 451 My…Read the article
-
How to modify TList<record> value?
- by Astronavigator
How to modify TList < record value ? type TTest = record a,b,c:Integer end; var List:TList<TTest>; A:TTest; P:Pointer; .... .... List[10] := A; <- OK List[10].a:=1; <- Here compiler error : Left side cannot be assined to P:=@List[10]; <- Error: Variable requiedRead the article
-
how to find first and last record from mysql table
- by chetan
I have one table I want to find first and last record that satisfy criteria of particular month.Read the article
-
how to get the size of a record in mysql
- by Osama
How to get the size of a record in MySql if the table contains fields of type TEXT or BLOB?Read the article
-
Rails - Active Record :conditions overrides :select
- by Nick
I have a fairly large model and I want to retrieve only a select set of fields for each record in order to keep the JSON string I am building small. Using :select with find works great but my key goal is to use conditional logic with an associated model. Is the only way to do this really with a lamda in a named scope? I'm…Read the article
-
Hashbytes comparison in stored proceduring not matching record
- by Michael Itzoe
The password field in my user table (SQL Server 2008) is encrypted using HASHBYTES on insertion. I have a stored procedure with parameters for the username and plain-text password which does a SELECT using that username and the password sent through HASHBYTES, then returns the user record if it finds a match. The SP is…Read the article
-
random record from mysql table
- by rshivaganesh
Is there any built-in function except order by random() to select a random record in mysql table?Read the article
-
Create or override Rails Active Record macros (
- by Jocelyn
In a Rails app, Active Record creates created_at and updated_at columns thank to macros, (it seems to be also called "magic columns"). See Active Record Migrations I have some questions about that mecanism: Is it possible to override that to get a third column (e.g. deleted_at) ? Is it possible to create a new macro…Read the article
-
SQL query: SUM values up to the current record
- by djeidot
Basically, having this table: 12.10 2.35 21.45 35.26 I want to, in each record, calculate the sum of all previous records, like this: 12.10 | 12.10 2.35 | 14.45 21.45 | 35.90 35.26 | 71.16Read the article
-
Key logger wont record key strokes without console
- by Daniel Gopar
I created a small basic key logger in C++. For some reason when I compile and run the program with the console displayed, it will record every key stroke I make in whatever program I am using such as a browser and store it in a text file. However when I make it so that it WON'T display a console window, it will not…Read the article
-
record mouse movements, clicks and keyboard input with Java or C++
- by Joe
I want to be able to record mouse movements, clicks and keyboard input from a user. It would be great if it was a cross platform solution. I'd like to get back something like this (pseudo code): mouse moved to 500, 500 mouse double clicked mouse moved to 800, 300 mouse left clicked keyboard typed "Hello World" …Read the article
-
sip.conf configuration file - add new line to each record
- by Flukey
I have a sip configuration file which looks like this: [1664] username=1664 mailbox=1664@8360 host=192.168.254.3 type=friend subscribemwi=no [1679] username=1679 mailbox=1679@8360 host=192.168.254.3 type=friend subscribemwi=no [1700] username=1700 mailbox=1700@8360 host=192.168.254.3 type=friend subscribemwi=no…Read the article
-
Lock record before updating?
- by Khou
Is there any disadvantage of locking a record before updating it?Read the article
-
[CakePHP] Pagination after inserting or updateing record
- by user198003
one more question related with cakephp... let's say that i have 20+ records in my table. they are sorted by some criteria, ie. by title. and on a list view, i have a list of 10 records, with available pagination. how can i achieve that when i insert new record, to be redirected to proper page, where i can see…Read the article
-
Erlang - list comprehensions - populating records
- by tbikeev
I have a simple record structure consisting of a header (H) and a list of the data lines (D) 1:N. All header lines must start with a digit. All data lines have a leading whitespace. There also might be some empty lines (E) in between that must be ignored. L = [H, D, D, E, H, D, E, H, D, D, D]. I would like…Read the article
-
RSpec leaves record in test database
- by DMiller
Whenever I run a user test, RSpec leaves the Fabricated user in the test database after the test has completed, which is messing up my other tests. I will do a rake db:test:prepare, but when I run my tests again, the record is recreated in my database. I have no idea why this is happening. It only happens with…Read the article
-
MS Access Can't move to a different record?
- by user986706
Ok, I'm really baffled. Here's the rundown: I've created a form with a subform. The main form is called FacilityInfo, and the subform is called BillingInfo. The forms are linked via 3 fields, AffiliateID, ClientID, and FacilityID. the subform shows one record at a time, set to show Continuous Forms, and…Read the article
