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
VOBCOPY(1)							   User Manuals 							VOBCOPY(1)

NAME
vobcopy - copy (rip) files from a dvd to the harddisk SYNOPSIS
vobcopy [-b size[bkmg] ] [-e size[bkmg] ] [-f] [-F fast_factor ] [-h] [-i input-dir ] [-l] [-m] [-M][-n title-number ] [-o output-dir ] [-q] [-O single_file(s)_to_rip ] [-t name ] [-v [-v]] [-x] [-I] [-V] [-L logfile-path ] [-1 aux_output_dir1 ] [-2 aux_output_dir2 ] [-3 aux_output_dir3 ] [-4 aux_output_dir4 ] DESCRIPTION
vobcopy copies DVD .vob files to harddisk (thanks to libdvdread) and merges them into file(s) with the name extracted from the DVD. It checks for enough free space on the destination drive and compares the copied size to the size on DVD (in case the size is wrong the files keep the .partial ending ). It should definitely work on linux and now on FreeBSD, OpenBSD, NetBSD, Solaris and MacOSX too! theCSSissue: Due to possible legal issues, vobcopy doesn't include any code to descramble CSS "enhanced" DVDs. CSS is sold by the DVD industry as a "copy protection", though it's more of a "view protection" as it makes DVDs unviewable with unlicensed players. Some people have hacked CSS decryption routines, and one of those is available as a libdvdread counterpart. So if you have such a DVD, have a look at the libdvdread page. If you are positive that it's allowed where you live, you can just install that mentioned library and make decrypted backups of all your DVDs... vobcopy without any options will copy the title with the most chapters into files of 2GB size into the current working directory. OPTIONS
-b, --begin SIZE[bkmg] begins to copy from the specified offset-size. Modifiers like b for 512-bytes, k for kilo-bytes, m for mega- and g for giga-bytes can be appended to the number. Example: vobcopy -b 500m will start to copy from 500MB onward till the end. -e, --end SIZE[bkmg] similar to -b, this options lets you specify some size to stop before the end. -f, --force force the output to the specified directory even if vobcopy thinks there is not enough free space -F, --fast fast_factor speed up the copying (experimental). fast_factor is in the range 1 to 64 -h, --help print the command line options available -i, --input-dir INPUT-DIR provide vobcopy with the path to the mounted dvd drive -l, --large-file write data into one file (needs large file support (LFS)) -M, --longest choose the title with the longest playing time. With some DVDs this gets the main title better than the most chapter method, with others it's worse. -m, --mirror mirrors the whole dvd to harddisk. It will create a directory named after the dvd and copy the ifo, bup and vob files there. The title-vobs are decrypted during this. -n, --title-number TITLE-NUMBER specify which title vobcopy shall copy (default is title with most chapters). On the dvd, vts_01_x.vob specify the first title (mostly this is the main feature). -o, --output-dir OUTPUT-DIR specify the output-directory of the data. "stdout" or "-" redirect to stdout. Useful for pipeing it to /dev/null ;-) If you forget to pipe it to some place, your terminal will get garbled, so remember that typing "reset" and then Enter will rescue you. -q, --quiet all info- and error-messages of vobcopy will end up in the current directory in vobcopy.bla instead of stderr -O, --onefile single_file(s)_to_rip specify which single file(s) to rip. Parts of names can be given and all files which include the part will be copied. Files can be listed with comma separation. Example: -O video_ts.vob,bup will copy the single file video_ts.vob and all files containing bup -t, --name NAME you can give the file a name if you don't like the one from dvd. -t hallo will result in hallo.vob. (stdout or "-" are deprecated now) If you want to give it names like "Huh I like this movie", do it in quotation marks. -v, --verbose prints more information about whats going on (more verbose). -v -v prints the information given on command line into a log-file in the current directory for inclusion into a bugreport. -x overwrite all existing files without further questions. -L LOGFILE-PATH tells vobcopy where to put the logfile instead of the default. -I, --info prints information about the titles, chapters and angles on the dvd. -V, --version prints version number. -1, --1st_alt_output_dir AUXILIARY-OUTPUT-DIR1 if the data doesn't fit on the first output-directory (specified behind -o) writing will continue here (and after -2 there and -3 and -4) -> the files will be split according to the remaining free space (try specifying the path _directly_ behind -1, _no_ space in between if you have troubles, this might be even necessary at -o...) BUGS
Vobcopy is still under development. So expect some. There *might* be problems for users who's system is not large-file ready. If so, please get back to me. AUTHOR
Robos <robos@muon.de> Linux Jun 2009 VOBCOPY(1)
All times are GMT -4. The time now is 02:23 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy