Sponsored Content
Top Forums Programming SQL: Alter existing bool after printing Post 302891369 by Franklin52 on Wednesday 5th of March 2014 10:16:03 AM
Old 03-05-2014
Quote:
Originally Posted by sea
Misleaded from the first finding, it seems i had made too many unrequired changed while generating the command...

This one (from Oracle) helped me:
Code:
'SQL_NEW = "UPDATE customer SET name='Joe' WHERE customer_id=10;"        ' copied example
SQL_NEW = "UPDATE tblDataBuch SET Gedruckt=true WHERE Gedruckt=false;"  ' my changes

/solved

EDIT:
Thank you Franklin52, but that line results in a runtime error 3078 of VBA, allthough there is none (grammer-error) I see..
Try to run the sql string like this:
Code:
DoCmd.RunSQL SQL_NEW

This User Gave Thanks to Franklin52 For This Post:
 

10 More Discussions You Might Find Interesting

1. AIX

Can't alter bootlist

Made a sysback tape backup on our 595 running 4.1.5 but when trying to do a restore discovered that rmt0 not in bootlist(s). Tried to alter both the normal and service bootlists but system wont respond to F7(commit). Erased the service boolist then tried alter again, same result. Now have... (2 Replies)
Discussion started by: mooshkie
2 Replies

2. Shell Programming and Scripting

folder existing and file existing

I want to look into a folder to see if there are any folders within it. If there are, I need to check inside each folder to see if it contains a .pdf file So If /myserver/myfolder/ contains a folder AND that folder conatins a .pdf file do X Else do Z I may have multiple folders and... (4 Replies)
Discussion started by: crowman
4 Replies

3. Solaris

Add existing user into an existing group

Pre: no gpasswd/adduser there is just usermod can be used, also there is no -a option for usermod. How should I add a user into a group? (4 Replies)
Discussion started by: a2156z
4 Replies

4. Shell Programming and Scripting

Need help in printing a sql query in perl

Hi All, I have the following sql query select abcd from udbadm.log where xyz='1'. I have 16k queries similar to this with different values for xyz. I want to print the values of 'abcd' for each row. I have the following perl code, but not sure how i can print that particular... (1 Reply)
Discussion started by: userscript
1 Replies

5. Shell Programming and Scripting

insert pipes for existing and non-existing records

I have a source file like this, L4058S462 34329094 F51010141TK1070000483L4058S462 34329094 0232384840 381892 182 5690 L4058S462 34329094 F51020141FIRST CLEARING, LLC A/C 3432-9094 L4058S462 34329094 F51030141JOHAN HOLMQVIST ... (1 Reply)
Discussion started by: saravanamr
1 Replies

6. Programming

Error message: invalid types 'bool...' (array problem)

Hello everyone. I'm stuck with an error message that neither I nor any of my computer science peeps can understand. The program I wrote is meant to be a simple decimal to binary converter, but with this message it's more complicated than I thought. Here's the code: #include <iostream>... (2 Replies)
Discussion started by: qf_woodfox
2 Replies

7. Programming

Error message: invalid types 'bool...' (array problem)

Hello everyone. I'm stuck with an error message that neither I nor any of my computer science peeps can understand. The program I wrote is meant to be a simple decimal to binary converter, but with this message it's more complicated than I thought. Here's the code: #include <iostream>... (3 Replies)
Discussion started by: qf_woodfox
3 Replies

8. Shell Programming and Scripting

Alter existing script to work with longer file name

I have this script: #!/bin/sh for file in "$@" do ext=${file##*.} base=${file%.*} num=${base##*v} zeroes=${num%%*} num=${num#$zeroes} #remove leading zeros, or it uses octal num=$((num+1)) base=${base%v*} new=$(printf... (4 Replies)
Discussion started by: scribling
4 Replies

9. UNIX and Linux Applications

SQL - how to alter info of a cell in table

Hello, I am newbie on mysql and trying to edit my database from terminal under linux. What I need to do is to change the information written in a cell in table. Let me explain what I tried: $ mysql -u mysqluser -p $ show databases; $ USE catalogue; $ show tables ; $ select * from... (2 Replies)
Discussion started by: baris35
2 Replies

10. Programming

Bool vs char * conversion

I have a problem at make step to install a downloaded package consisted of different programs. In file included from kcdbext.cc:16:0: kcdbext.h: In member function �char* kyotocabinet::IndexDB::get(const char*, size_t, size_t*)’: kcdbext.h:1281:14: error: cannot convert �bool’ to... (3 Replies)
Discussion started by: yifangt
3 Replies
TGTIMG(8)																 TGTIMG(8)

NAME
tgtimg - Linux SCSI Target Framework Image File Utility SYNOPSIS
tgtimg [-o --op <operation>] [-Y --device-type <device-type>] [-b --barcode <barcode>] [-s --size <size>] [-t --type <media-type>] [-f --file <path>] tgtimg --help DESCRIPTION
Tgtimg is a utility to create and manage the image files used by the TGTD device emulation. This command is used to initialize device image files with the additional metadata, such as barcode, list of blocks, total size, etc that the TGTD emulation needs. OPTIONS
-h, --help Show a help screen and exit. -o, --op {new|show} Operation. Is either new to create a new image file or show to show the content of an existing image file. -Y, --device-type <type> This specifies the type of image file. Supported device types are : cd : to create media for a dvd device disk : to create media for a disk device tape : to create media for a tape device -t, --type <media-type> When creating a new image, this specifies the type of media to emulate. The available mediatypes depend on the type of the device. Supported media types for cd devices are : dvd+r : create a blank writeable DVD+R disk Supported media types for disk devices are : disk : create an empty disk Supported media types for tape devices are : data : create a normal data tape clean : create a cleaning tape worm : create a worm -b, --barcode <barcode> When creating a new image, this argument specifies the barcode to use with this image file. Backup application software often uses barcodes to identify specific tapes. When emulating a VTL, make sure that all tape images use unique barcodes. -s, --size <size> When creating a new image, this specifies the size in megabytes for the virtual tape image. -f, --file <path> The filename of the image file. EXAMPLES
To create a new 100MByte disk tgtimg --op new --device-type disk --type disk --size 100 --file /data/hd001.raw To create a new tape image tgtimg --op new --device-type tape --barcode 12345 --size 100 --type data --file /data/tape001.img To view the content of an existing image tgtimg --op show --device-type tape --file /data/tape001.img To create a new blank DVD+R image tgtimg --op new --device-type cd --type dvd+r --file /data/dvd001.iso SEE ALSO
tgtd(8), tgtadm(8), tgt-admin(8), tgt-setup-lun(8). http://stgt.sourceforge.net/ REPORTING BUGS
Report bugs to <stgt@vger.kernel.org> 04/04/2010 TGTIMG(8)
All times are GMT -4. The time now is 04:59 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy